Date Format Conversion

[akpofureenughwu]

Hello,

How do one convert a date format from dd/mm/yyyy to yyyy/mm/dd?

I attached a sample excel sheet.

Regards

[its_anandrjs]

In your load script make change for this set expression by this all date present in your qlik file change to YYYY/MM/DD format

SET DateFormat='YYYY/MM/DD';

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff]';

See the attached file

Regards

Anand

[akpofureenughwu]

Thank you sir but  what if I want to use a script to change it. How do I do it?

Regards

[Chanty4u · Accepted solution]

Hi,

you can change like below

Load *,

Date(Date#(Datefiled,' dd/mm/yyyy'),'yyyy/mm/dd') as NewDate

resident  OldTable;

[its_anandrjs]

In your qlik file go to set expression >> By pressing Ctrl + E keys on the key board >> and find Set expressions

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='YYYY/MM/DD';

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Regards

Anand