When you’re summarising data from one table into another in Dashpivot (for example, from a default or prefilled table into a display/summary table), you may want the dates shown in a specific format (e.g., DD/MM/YYYY or MMM DD, YYYY). You can achieve this using the TEXT() formula to convert raw date values into your preferred display format.
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
In the Template Editor, add or identify your data table (Default or Prefilled) — this will be your Source_Table.
Add a Prefilled summary/ display table — this will show your formatted date.
In the summary table, set your display cell as a Formula field.
Enter the
TEXT()formula to format the date:
=TEXT(Source_Table!Source_Cell, "Format")
Replace:
Source_Table with your source data table name.
Source_Cell with the specific cell in the data table that contains the date.
Format_Text with the date format you want (in quotes).
Common Date Format Examples
"DD/MM/YYYY"→ e.g.,31/12/2024"MM/DD/YYYY"→ e.g.,12/31/2024"DD-MM-YYYY"→ e.g.,31-12-2024"YYYY-MM-DD"→ e.g.,2024-12-31"DDD"for three-letter day abbreviation (Mon, Tue, etc.)"DDDD"for full weekday name (Monday, Tuesday, etc.)
Example
To display a date from Table1 cell A1 in DD/MM/YYYY format:
=TEXT(Table1!A1, "DD/MM/YYYY")