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:

      2018-02-13T21:03:38+00:00

       

      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:

      'YYYY-MM-DDThh:mm:ss+00:00'

       

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

       

      When I do something like this:

      TimeStamp(Max(MyDateField))

      I get:

      2018-02-13P08:40:53+00:00

       

      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.

       

      Thanks