4 Replies Latest reply: Aug 26, 2014 2:54 AM by Herbert Chitate RSS

    Time stamp

      Morning All,

       

      I have a bit of an unusual time stamp that just wont cooperate. The date looks like this "2014/the following in my scriot05/21 12:09:22 PM" and I am trying to use the following in my script: " Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT'),'YYYY/MM/DD') as ADate" but is just not converting to a date, can anyone throw in some suggestions?

       

      Thank you

       

      H