topic Re: Load date which is in different format in QlikView

Load date which is in different format

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

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

Re: Load date which is in different format

ziadm — Wed, 26 Jul 2017 17:13:54 GMT

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

Re: Load date which is in different format

vishsaggi — Wed, 26 Jul 2017 17:29:01 GMT

Try this?

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

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

Re: Load date which is in different format

Anonymous — Wed, 26 Jul 2017 17:32:11 GMT

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?

Re: Load date which is in different format

Anonymous — Wed, 26 Jul 2017 17:34:09 GMT

Thanks, this works