How can I alter the date format in datatips?

Return to top

2 Comments

  • 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!

    0
  • 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!
    0

Please sign in to leave a comment.

Powered by Zendesk