topic Re: Date format conversion in variable in QlikView

Date format conversion in variable

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm having issue when I set variable($p) in date. I want to read file for today's date and store into 1 QVD file.:

vToday = Date(Today(), 'DD-MM-YYYY');

//vToday=14-03-2016

LET p = $(vToday);

//p=-2005

Tmp_Table:

LOAD *

FROM

[..\..\FileName_$(p).xls]

STORE Tmp_Table into ..\..\_$(p).QVD;

DROP Table Tmp_Table;

I able to get vToday value, but when I call the variable in p I get the value as '-2005'. How can I solve this P value.

Thanks a lot !

Re: Date format conversion in variable

sunny_talwar — Mon, 14 Mar 2016 16:50:11 GMT

Try this may be:

May be try this:

vToday = Date(Today(), 'DD-MMM-YYYY');

//vToday=14-Mar-2016

LET p = $(vToday);

//p=-2005

Tmp_Table:

LOAD *

FROM

[..\..\FileName_$(p).xls]

STORE Tmp_Table into ..\..\_$(p).QVD;

DROP Table Tmp_Table;

Re: Date format conversion in variable

Tue, 15 Mar 2016 01:12:03 GMT

Dear Sunny,

I get this error :

Cannot open file 'D:\..\FileName_.xls' The system cannot find the file specified.

Forgot to mention my filename is File_DD-MM-YYYY.

Re: Date format conversion in variable

engishfaque — Tue, 15 Mar 2016 03:58:52 GMT

Dear Syashairi,

Kindly find attached App, for quick reference script is given below.

LET vToday = Date(Today(), 'DD-MM-YYYY');

LET p = '$(vToday)';

Table1:

LOAD Product,

Sales

FROM

[Sales_$(p).xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE Table1 into $(p).qvd;

DROP Table Table1;

Kind regards,

Ishfaque Ahamed

Re: Date format conversion in variable

Tue, 15 Mar 2016 07:39:17 GMT

Hi Ishfaque,

It works, Thanks so much!