
+6
All Reports: Break out Date and Time into Separate Columns
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.
Customer support service by UserEcho
ALSO SEVERAL OF THE REPORTS, WHEN DOWNLOADED, COME INTO EXCEL WITH MISMATCHED DATA TYPES. NUMBERS COME IN AS TEXT AND WE HAVE TO USE THE TEXT TO COLUMNS FUNCTION TO USE THEM AS NUMBERS. NOT EVERYONE KNOWS HOW TO DO THIS.