Docs  /  Excel Report Builder  /  Edit Evaluations  /  Tips & Tricks

 Get month name from date

2024/10/24 • 1 min. to read
If you want to determine the month name from a date field, it is best to use Text Formatting in the Field Settings of the date field. 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.