Author Topic: Format Date Column When Exporting Reports  (Read 1033 times)

317paddy

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
    • View Profile
Format Date Column When Exporting Reports
« 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!


mirkox

  • Loway
  • Full Member
  • *
  • Posts: 201
  • Karma: 3
    • View Profile
Re: Format Date Column When Exporting Reports
« Reply #1 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

317paddy

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
    • View Profile
Re: Format Date Column When Exporting Reports
« Reply #2 on: November 25, 2014, 18:09:56 »
Thanks for the suggestion Mirko!  I'll give it a shot.