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

    Using Date in Script

    Stuart Wenzel

      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];