topic Re: Using Date in Script in QlikView

Using Date in Script

Tue, 19 Mar 2013 17:35:05 GMT

Using tthis code, QVDATE = 2-28-2013. Why does [As of Date] show as 5-31-1894?

Pol:
LOAD date(max([Month End Date]),'MM-DD-YYYY') as MonthEndDate1
FROM policy$(LoadYear).qvd (qvd);

LET QVDATE = peek('MonthEndDate1', 0, 'Pol');

Drop Table Pol;

MRSS:
LOAD *,
Date($(QVDATE),'MM/DD/YYYY') as [As of Date];

Gysbert_Wassenaar — Tue, 19 Mar 2013 17:43:29 GMT

Try: Date#('$(QVDATE)','MM/DD/YYYY') as [As of Date];

$(QVDATE) will be evaluated as 2 - 28 - 2013 = -2039 if you use it in the date() function. Try it in a textbox to see what happens: =date(-2039)

CELAMBARASAN — Tue, 19 Mar 2013 17:48:16 GMT

MRSS:

LOAD *,

Date('$(QVDATE)','MM/DD/YYYY') as [As of Date];

Use enclose the variable expression in single quotes.