topic Re: Date in test format. in QlikView

Date in test format.

Sun, 19 Oct 2014 13:42:56 GMT

Hai all,

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

Re: Date in test format.

ashfaq_haseeb — Sun, 19 Oct 2014 13:50:51 GMT

Yes you can convert textual date to dates.

can you attach few lines of sample data?

Regards

ASHFAQ

Re: Date in test format.

its_anandrjs — Sun, 19 Oct 2014 14:04:51 GMT

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

Re: Date in test format.

maxgro — Sun, 19 Oct 2014 14:16:36 GMT

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

Re: Re: Date in test format.

Mon, 20 Oct 2014 16:29:56 GMT

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.

Re: Re: Re: Date in test format.

ashfaq_haseeb — Mon, 20 Oct 2014 17:51:48 GMT

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