How can I alter the date format in datatips?

Question

I have changed the date format in most parts of my report, however, the new format isn't taken into consideration in the datatips. How can I change the date format in datatips?

Answer

To alter the date format in datatips, create a standard calculated attribute and then add it to your report. If, for example, your report belongs to the tickets dataset and you are using the Ticket created- Date attribute, create a custom attribute with the below formula:

DATE_FORMAT([Ticket created - Date],"DD-MM-YYYY")

You can then modify the datatips in your report to include the modified attribute.

For a full list of supported date formats and examples, see Explore functions reference.

For more information, see Working with datatips.