Correct formatting for a date object

[Anonymous]

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.

[sunny_talwar]

Try this

='(' & Concat({$} DISTINCT Chr(34) & Date(MONTHandYEAR, 'MMM-YYYY') & Chr(34),'|') & ')'

[Anonymous · Accepted solution]

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.

[sunny_talwar]

Awesome!!! I am glad I was able to help.

Best,

Sunny