Format Date Column When Exporting Reports

[317paddy]

It would be helpful if the "Date" column was formatted like "yyyy-mm-dd hh:mm:ss", so that the field is recognized as a date when a report is exported to excel.  This allows for more flexibility when analyzing data via excel (sorting/grouping by day, hour, etc.).

Thanks!

[mirkox]

Hi 317paddy,

that's a good suggestion but not all QM users will like that; what you could do is to modify the language file in order to change the date format.

/usr/local/queuemetrics/qm-current/WEB-INF/LIntl/queuemetrics_en_US.properties

Date formats are in the beginning of the file.

Kind Regards
Mirko

[317paddy]

Thanks for the suggestion Mirko!  I'll give it a shot.