QueueMetrics forum

QueueMetrics => Improving QueueMetrics => Topic started by: 317paddy on November 20, 2014, 22:57:56

Title: Format Date Column When Exporting Reports
Post by: 317paddy on November 20, 2014, 22:57:56

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!

Title: Re: Format Date Column When Exporting Reports
Post by: mirkox on November 21, 2014, 11:35:16

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

Title: Re: Format Date Column When Exporting Reports
Post by: 317paddy on November 25, 2014, 18:09:56

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