...
You can specify the format that is used to view date columns where the actual data is not changed, just how it is displayed. This helps to keep the data looking consistent even if the provided data is not. This can be enabled with the M column type for the Column types parameter corresponding to the column. Advanced date sorting specifies how to use the M column type to customize how the column data is interpreted as a data. With an additional specification, the format of how the date must appear when viewed.
...
The formatting options listed on this page can be defined through the Column types parameter within the following macros:
- CSV macro
- Table Plus macro
- Attachment Table macro
- JSON Table Macro
- SQL Macro
- SQL-query Macro
- SQL-file Macro
- Excel Macromacro
Screenshot
Formatting options
...