How can I alter the date format in datatips?

Return to top


  • Rockford Hipp

    I am having trouble generating the three-letter month name abbreviation. Is "MMM-YY" possible in Zendesk? Can I not do this because Explore wouldn't know how to sort in ascending order along a given axis? Thanks!

  • Dave Dyson
    Zendesk Community Manager
    Hi Rockford!
    There isn't an argument you can supply to the DATE_FORMAT function that will give you the first three letters of the month, so you'll need to create a Standard Calculated Attribute with the following as the formula:
    LEFTPART(MONTH([Ticket created - Date]),3)+"-"+YEAR([Ticket created - Date])
    Hope that helps!

Please sign in to leave a comment.

Powered by Zendesk