Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert date format.
ex: from 8/11/2015 to the format 8-Aug-2015.
Thank you.
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
date(date#('8/11/2015','M/D/YYYY'),'D-MMM-YYYY')
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
hi!
Try.
=Date(Date#('8/11/2015'),'DD-MMM-YYYY')
Regards.