Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

hkg_qlik
Contributor III

Modify Date

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

Tags (1)
1 Solution

Accepted Solutions

Re: Modify Date

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

3 Replies

Re: Modify Date

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
Contributor III

Re: Modify Date

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

Re: Modify Date

Hi

Try like this

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