topic Re: how to convert multiple date format's into single format in QlikView

how to convert multiple date format's into single format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how to convert multiple date format's into single format

vishsaggi — Wed, 19 Apr 2017 21:04:34 GMT

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

Re: how to convert multiple date format's into single format

Anonymous — Wed, 19 Apr 2017 21:40:54 GMT

thanks nagaraju