Create Custom Date Format in Zendesk Reports
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 are displayed in your reports, including in datatips, by creating a standard calculated attribute and adding it to your report.
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:…
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…
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…
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?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
