Explore DATE_FORMAT doesn't return 24 hour time
I've referred to the function reference to create a calculated attribute. The documentation here https://support.zendesk.com/hc/en-us/articles/360022184834-Explore-functions-reference#topic_esm_5qg_dhb indicates that i can use the following options for my output format
| Hour in day (0-23) | H | 3 |
| Hour in day (1-24) | k | 3 |
| Hour in AM/PM (0-11) | K | 3 |
| Hour in AM/PM (1-12) | h | 3 |
I have used the following calculation in my attribute
DATE_FORMAT([Ticket created - Timestamp],"dd-MM-HH:00")
Unfortunately, i do not appear to get a 24 hour value for my 'hours' portion of the date, the values only run from 1-12. Any suggestions around why this might not be working would be greatly appreciated.
-
Hello Daniel,
Thank you for bringing this to our attention. I've created a ticket for you to further discuss this issue so I can get more details.
-
Is there any news about this issue? I'm having the same problem.
-
Hi Andres K.
Thanks for reaching out! We have raised this issue with our Dev team and they are still investigating this issue. In the meantime, they recommend using this formula as a workaround:DATE_FORMAT([Ticket created - Timestamp],"dd-MM-HH24:00")
Best,
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
3 Kommentare