Load date which is in different format

[Anonymous]

Hello All,

I have a date column where the values are in the format of 18-'Aug'-2017, how can I load the record?

Thanks,

Niharika

[ziadm]

Date(Date#(DateField,'DD-MMM-YYYY'),'YYYY-MM-DD')

[vishsaggi · Accepted solution]

Try this?

Date(Date#(Replace(Date, Chr(39), ''), 'DD-MMM-YYYY'), 'DD-MMM-YYYY')

OR

Date(Date#(Replace(Date, Chr(39), ''), 'DD-MMM-YYYY'), 'MM/DD/YYYY')

[Anonymous]

Hi Ziad,

The expression will work for the values which are in 'DD-MMM-YYYY' format, by the value I have is in 'DD-'MMM'-YYYY' format(Month in single quotes).So this wont work, is there any other way?

[Anonymous]

Thanks, this works