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,