Modify Date

[hkg_qlik]

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,

H

[MayilVahanan · Accepted solution]

Hi

Try like this

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

or

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

[hkg_qlik]

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.

H

[MayilVahanan]

Hi

Try like this

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