12 Replies Latest reply: May 17, 2013 10:57 AM by Rob Wunderlich RSS

    time stamp issue

    Sukhwant Matharoo

      hi all



      i am importing raw data from MS Access and Date column in MS Access has date followed by time stamp


      5/16/2013 12:00:00:00


      when i load the raw data and i compare the date column with variable declared in script


      tdate= date (today(),'M/D/YYYY');


      load * from MS access table where Date='$(tdate);



      this gives an error of mismatch format



      please advise for to resolve in script