Date formula conversion

[Ameya09]

How to convert date in below format which is output of previous block : 

2026-06-17T09:25:35Z 

What to input in the input and output formats if date formula is to be used?

[priscilarubim · Accepted solution]

Hi @Ameya09 ,

Quick heads up on what is going on here: the Date formula in Qlik Automate does not use Qlik Sense date tokens. It is PHP style formatting under the hood, so YYYY and DD will not do what you are used to from the load script. That is the whole problem.

Good news is your value, 2026-06-17T09:25:35Z, is plain ISO 8601, so the formula reads it with no help at all. Leave the Input format blank and it parses fine. If you would rather spell it out, it is Y-m-d\TH:i:s\Z. The backslashes on the T and Z are not optional, since both are real tokens (timezone stuff), so without escaping them the formula tries to interpret them instead of reading them as text.

For the output, your DD/MM/YYYY hh:mm A becomes d/m/Y h:i A.

Watch the minutes, because this is the one that catches everybody: minutes is i, not m. The m token is the month, so mm prints the month twice instead of the time. With d/m/Y h:i A you get 17/06/2026 09:25 AM.

Want a 24 hour clock instead? Use H and drop the A. So d/m/Y H:i gives you 17/06/2026 09:25.

Token list is here if you want it bookmarked: https://community.qlik.com/t5/Official-Support-Articles/Formatting-datetimes-in-Qlik-Application-Aut...