Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a date object entitled MonthandYear (i.e. 'Jun-2017') and currently in the process of using the following formula:
='(' & concat({$} distinct chr(34) & MONTHandYEAR & chr(34),'|') & ')'
The result is a listing of dates formatted this way (i.e. ("42736"| "42767" | "42795"). How can I changed the formula above to show the dates as they are in the object (..e. 'Jun-2017'). I've tried solving this myself but for some reason am having an issue with it.
Thanks for your help.
Hi Sunny,
Thanks for the help. It worked. Not sure why I could not get it to work on my own.
Thanks again for all of your help.
Try this
='(' & Concat({$} DISTINCT Chr(34) & Date(MONTHandYEAR, 'MMM-YYYY') & Chr(34),'|') & ')'
Hi Sunny,
Thanks for the help. It worked. Not sure why I could not get it to work on my own.
Thanks again for all of your help.
Awesome!!! I am glad I was able to help.
Best,
Sunny