topic Re: Modify Date in QlikView

Modify Date

hkg_qlik — Tue, 19 Nov 2013 23:07:57 GMT

Hi all,

I have a calendar table with date field as YYYY/MM/DD (Data Warehouse table)

I would like to convert all dates into MM/DD/YYYY while loading the table from DW.

Regards,

MayilVahanan — Tue, 19 Nov 2013 23:11:18 GMT

Try like this

Date(DateField,'MM/DD/YYYY') // If its in date format.

Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY') // If its not in date format

hkg_qlik — Tue, 19 Nov 2013 23:21:22 GMT

Hi Mayil,

Thanks for the solution---- > Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY')

If I want to convert it to MM/DD/YY 00:00:00 ?

Regards.

MayilVahanan — Wed, 20 Nov 2013 14:09:38 GMT

Try like this

Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY hh:mm:ss')