Date in test format. - Qlik Community

Report Inappropriate Content · ‎2014-10-19

Hai all,

I have converted .XML file into .XLSX and uploaded. Then date has picked as test format. Can I change it in QVD.

ashfaq_haseeb · ‎2014-10-19

Yes you can convert textual date to dates.

can you attach few lines of sample data?

Regards

ASHFAQ

its_anandrjs · ‎2014-10-19

Provide any sample data and with the help of Date#() and Date() function you can achieve this.

maxgro · ‎2014-10-19

when you read from xlsx

use an interpretation function Date#(string, format) to convert from string to number

date#( A, 'YYYY.MM.DD' )

where A=1997.08.06 returns 35648

Report Inappropriate Content · ‎2014-10-20

27-FEB-2014

28-FEB-2014

07-MAR-2014

28-FEB-2014

above records has to convert into date format because I need date calculation. as per above its uploading as test .

Thanks,

Dhanushka.

ashfaq_haseeb · ‎2014-10-20

Hi,,

Try below and let me know if that worked,

Load *, Date(Date#(Date,'DD-MMM-YYYY'),'DD/MM/YYYY') as NewDate;
load * Inline
[
Date
27-FEB-2014
28-FEB-2014
28-FEB-2014
07-MAR-2014
28-FEB-2014
28-FEB-2014
28-FEB-2014
28-FEB-2014
];

Regards

ASHFAQ