Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
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)
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)
MRSS:
LOAD *,
Date('$(QVDATE)','MM/DD/YYYY') as [As of Date];
Use enclose the variable expression in single quotes.