Report Export β MonthYear Column Type Support
The modern reporting platform supports multiple column data types that control how values are formatted in exported files. This article explains the monthyear column type, which renders date values as a month-and-year combination in the on-screen report grid and in both CSV and XLSX exports.
Before you begin
- You must have access to a report that includes a column configured with the
monthyeardata type. - Exports are available in XLSX (default) and CSV formats. Click Export to download the file.
On this page
How it works
When a report column is defined with the monthyear data type, the report export engine renders the column's date value using the MonthYear format token. This means each cell in that column displays the month and year of the underlying date β for example, rendering a date as Jan 2025 rather than as a full date or a date-and-time value.
This behavior applies consistently in the report grid and in both export formats:
- Report grid β The column displays the month and year in each row.
- XLSX β The column renders as a month-and-year formatted string in each row.
- CSV β The column renders as a month-and-year formatted string in each row.
The monthyear type extends the set of supported column data types, which includes:
| Column data type | Description |
|---|---|
text |
Left-aligned text value |
number |
Right-aligned numeric value |
money |
Right-aligned value with currency symbol |
date |
Locale-formatted full date |
percentage |
Right-aligned value with % suffix |
monthyear |
Month-and-year formatted date (for example, Jan 2025) |
The monthyear type is distinct from date and datetime. Use it when a report column represents aggregated or period-level data where the day component is not meaningful β such as monthly revenue summaries or period-based membership counts.
Key features
- Consistent across formats β The
MonthYearformat token applies identically in both XLSX and CSV exports, so the rendered value is the same regardless of which format you download. - Extends existing type support β The
monthyeartype works alongside the existingdateanddatetimetypes. Each column in a report uses exactly one type, and the export engine applies the corresponding format token automatically. - No additional configuration required β When a report column is defined with the
monthyeartype, the format is applied at export time without any additional steps by the user.