image for site

Display Month as Three-Letter Abbreviation in Zendesk

Find out how to use the DATE_FORMAT function to show months as three-letter abbreviations in Zendesk reports.

Is it possible to display the month as a three-letter abbreviation in Zendesk?

Yes, you can display the month as a three-letter abbreviation in Zendesk by using theDATE_FORMATfunction with the formatMon DD YYYY. This will return the date with the month abbreviated to three letters, such as 'Mar 21 2022'.

However, be aware that using this format in a graph may result in the data being sorted alphabetically rather than chronologically. To address this, you can create an ordered set to ensure the months are displayed in the correct order.


More related questions

How can I change the date format in datatips in Zendesk reports?

To change the date format in datatips, you need to create a standard calculated attribute and add it to your report. For instance, if your report uses the Ticket created - Date attribute, you can create a custom attribute with the formula:…

How can I sort months chronologically when using three-letter abbreviations in Zendesk?

To sort months chronologically when using three-letter abbreviations, you can create an ordered set to display the values in the correct order. Alternatively, you can use a time-based date attribute, such as Ticket Created - Date, and adjust the…

What is the formula to create a custom date format in Zendesk?

To create a custom date format in Zendesk, you can use theDATE_FORMATfunction. For example, to format a date as 'DD-MM-YYYY', you would use the formula:DATE_FORMAT([Ticket created - Date],"DD-MM-YYYY"). This allows you to customize how dates…

Can I use the 'MMM-YY' format in Zendesk Explore?

Yes, you can use the 'MMM-YY' format in Zendesk Explore by applying a time-based date attribute and adjusting the date format in the Chart Configuration settings. EnterMMM YYin the Date Display Format field to achieve this format. This allows…

Interested indeflectingover 70% of your Zendesk support tickets?

Our AI customer support agent is here to help. Trained on all your help docs, installed directly into your Zendesk account, it can be used to automate customer replies for tickets or live chat. Learn more below.
Zendesk logo

Zendesk Support Tickets

Receive new tickets by email or a support form? This integration is for you.
My AskAI integrated within Zendesk to deflect support tickets
Learn about our Zendesk ticket integration
Zendesk logo

Zendesk Messaging (live chat)

Using Zendesk's Messaging widget on your site for live chat? This integration is for you.
My AskAI integrated within Zendesk to deflect customer support live chat conversations
Learn about our Zendesk Messaging integration

Join1,000+ companies reducing their support costs and freeing up support agents for more important work

Vestd company logo — Customer of My AskAI's AI customer support agents
Genesis company logo — Customer of My AskAI's AI customer support agents
Zinc company logo — Customer of My AskAI's AI customer support agents
Customer.io company logo — Customer of My AskAI's AI customer support agents
Zeffy company logo — Customer of My AskAI's AI customer support agents
NHS company logo — Customer of My AskAI's AI customer support agents
Kontakt.io company logo — Customer of My AskAI's AI customer support agents

Reduce support costs.Spend more time on customer success.

Our AI customer support agents are already used by 👇
Companies using AI assistants on their websites