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.
Please sign in to leave a comment.