Date format

[#1]

How to convert date format.

ex: from 8/11/2015 to the format 8-Aug-2015.

Thank you.

[Gysbert_Wassenaar]

date(date#('8/11/2015','M/D/YYYY'),'D-MMM-YYYY')

[sunny_talwar · Accepted solution]

Do you mean to get 8-Nov-2015 or 11-Aug-2015??

If 8-Nov-2015 -> Date(Date#(DateField, 'D/MM/YYYY'), 'D-MMM-YYYY')

If 11-Aug-2015 -> Date(Date#(DateField, 'M/DD/YYYY'), 'D-MMM-YYYY')

HTH

Best,

Sunny

[Anonymous]

hi!

Try.

=Date(Date#('8/11/2015'),'DD-MMM-YYYY')

Regards.