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.
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
1 Kommentare