+3

All Reports: Break out Date and Time into Separate Columns

Angela Petschow (Admin) 1 month ago in Reports 0

Problem Statement: Today, most of the reports group date & time into one column. When exporting into Excel, it is a formatting nightmare AND Excel does not sort this column entirely. So, for example: when we run a reservations report for the month, export it to Excel, then try to sort on Start Date / Time (ascending)

... it skips rows as if it doesn't recognize the date/time format.


It would be great if all the reports (including transactions Reports) could break out the Date/Time Column into TWO separate columns. This would allow for easier sorting & utilizing PivotTables in Excel.


Image 313