topic Re: Date Format Conversion in QlikView

Date Format Conversion

akpofureenughwu — Sun, 13 Nov 2016 10:44:26 GMT

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 — Sun, 13 Nov 2016 10:48:49 GMT

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 — Sun, 13 Nov 2016 10:57:04 GMT

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

Regards

Chanty4u — Sun, 13 Nov 2016 11:10:54 GMT

Hi,

you can change like below

Load *,

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

resident OldTable;

its_anandrjs — Sun, 13 Nov 2016 11:20:30 GMT

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