Date conversion 15/Aug/2016 09:49:44

1

Hi,

What’s the best way to convert this date format under Excel like ‘15/Aug/2016 09:49:44’ to a date format in Easymorph ?
I tried date([Date],‘dd/mm/yyyy hh:mm:ss’), but it failed.

Thanks
MichelDateIssue.xlsx (149.0 KB)

2

Hi Michel, try

date([Date],'d/MMM/yyyy HH:mm:ss')

Notice that the format string is case-sensitive: upper-case M is used for months and lower-case m is used for minutes. Also lower-case hh is used for 12-hour clock, while upper-case HH is for 24-hour clock.

A few examples here, more examples here.

3

Thanks a lot !
Michel