Date datatypes

[lmit]

Hi All,

I have 2 different date formats in one singe row , so am trying to convert them into one format

for example my data is in below 2 formats

mm/dd/yyyy

EEE MMM dd HH:mm:ss zzz yyyy

and my output format should be in

mm/dd/yyyy

Can anyone suggest how to get this.

Thanks in advance

lmit

[gjeremy1617088143]

Hi @none none​ , I can suggest you to read the data as a string and use a custom routine to transform it to a date from different format.

Send me love and kudos