3 Replies Latest reply: Feb 20, 2018 12:22 PM by Sunny Talwar RSS

    Formatting data with escape character?

    Jonathan Vitale

      Hello all,


      I am interpreting timestamps from SurveyMonkey that look like this:



      The "T" and the "+00:00" seem to be constant. I see them on every timestamp.


      To work with them properly I tried setting the timestamp format to:



      But, the "T" is being interpretted by Qlik as "A" or "P" for a.m. or PM.


      When I do something like this:


      I get:



      So, is there a way to tell Qlik that the "T" in my timestamp format is not to be interpreted? Some sort of escape character? I also want to make sure that my outputted (max date) is in 24 hour time.