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

    Help converting to timestamp

    Tanya Ruppell



      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!