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

       

      thanks