25 Replies Latest reply: Apr 5, 2016 8:30 AM by Sunny Talwar RSS

    Interpret and format timestamp field

    Paul Johansson

      I have a Timestamp field that i want to interpret and format, but I can get it right.

       

      I want to convert field: 2016-04-04T11:16:44.327


      to Timestamp field: 2016-04-04 23:16:44

       

      That is, i want to remove the 'T' and remove the milliseconds. My thinking goes:


      =timestamp(timestamp#(replace(timevalue, 'T', ' '), 'YYYY-MM-DD H:MM:SS:FFF TT'), 'YYYY-MM-DD HH:MM:SS')

       

      But it doesnt give any reuslt.  Any pointers?

       

      thanks in advance,
      Paul