This content has been marked as final. Show 3 replies
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:
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.