how to convert multiple date format's into single format

[Anonymous]

Hi,

i tried to convert multiple date formats into one single format but few dates are not converted here i selected the which are date formats not converted. Could you please help me below i attached the script and snapshot.

Date of letter field is source data from there i derived Date of letter1 field.

Script:

Converting_Dateformat:

LOAD

[Date of letter:]

,DATE(ALT(date#([Date of letter:],'DDMYYYY')

,Date#([Date of letter:],'MMDDYYYY')

,Date#([Date of letter:],'DMYYYY')

,Date#([Date of letter:],'MDDYYYY')

,Date#([Date of letter:],'MMDYYYY'),

))  AS      [Date of letter1:]

Resident Table;

Thanks,

Yuvaraj

[vishsaggi · Accepted solution]

Try this?

= IF(Len([Date of letter:]) = 7, Date(Date#(Floor([Date of letter:]), 'MDDYYYY'),'MM/DD/YYYY'),

   Date(Date#(Floor([Date of letter:]), 'MMDDYYYY'),'MM/DD/YYYY')) AS DateLetter1

[Anonymous]

thanks nagaraju