Using Date in Script

[#1]

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 · Accepted solution]

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]

MRSS:

LOAD *,

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

Use enclose the variable expression in single quotes.