Tempus

Build a useful date dimension

Create reporting dates and take them back to your spreadsheet.

4 min read · Reviewed 23 November 2026

Open Tempus
1

Explore one familiar date

Open Tempus and use Explore to see its calendar, ISO and Australian fiscal periods. Check the periods before exporting a range.

2

Choose your range in Build

Open Build and select an inclusive start and end date. The current release supports up to 36,600 days. Choose the fields or preset that match your reporting needs.

3

Review the preview

Check your date boundaries and field order in the preview. Corrected calculations are the default; workbook aliases are also available for the ISO labels and leap-year flag.

4

Download the files

Download the date dimension as CSV and keep the JSON schema alongside it. Use Fields to read the calculation definitions and coverage limitations.

Good to know

  • Holiday coverage is limited to the 2026 reference and excludes local and part-day calendars.

Troubleshooting

Can I add date fields to an existing CSV?

Use Join to import a date-keyed CSV, preview matches and exceptions, then export the enriched file, failed-row audit and summary.

All Tempus guides