★ Featured App

XML Builder
Export data in XML format (or JSON) via fully configurable schemas.
More information AppSource
Get month name from date
If you use the month field in a PivotTable as a column label, the sorting depends on the sorting of the records in the data sheet by default. This may produce the following result:
This can be prevented by specifying the sorting for the column name:
This produces the following result:
The example can be downloaded in the Download Area.
![]() | XML Builder Export data in XML format (or JSON) via fully configurable schemas. More information ![]() |