7 Replies Latest reply: Jul 7, 2017 4:28 PM by Tanya Ruppell RSS

    Help converting to timestamp

    Tanya Ruppell

      Hello,

       

      I have a timestamp field that looks like this:

      Screen Shot 2017-07-07 at 11.31.06 AM.png

       

      It is being read as text and I've tried using Timestamp# to convert it, but it is still tagged as $ascii $text:

       

          Timestamp#(Replace([timestamp],' GMT ',' '),'WWW MMM DD hh:mm:ss YYYY') as newTS,

       

      Screen Shot 2017-07-07 at 11.33.42 AM.png   Screen Shot 2017-07-07 at 11.37.57 AM.png

       

      Would really appreciate some help with this!

       

      Thanks,

      Tanya