2 Replies Latest reply: Mar 19, 2013 1:48 PM by Celambarasan Adhimulam RSS

    Using Date in Script

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


      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;


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