ZenotiHelp

Report Export β€” MonthYear Column Type Support

ZTZenoti Docs Team Updated October 13, 2026 2 min readReference

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 monthyear data 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 MonthYear format 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 monthyear type works alongside the existing date and datetime types. 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 monthyear type, the format is applied at export time without any additional steps by the user.
Was this article helpful?
Your feedback helps us improve our documentation.