QueueMetrics forum
QueueMetrics => Running QueueMetrics => Topic started by: Richarddb on January 13, 2011, 10:36:17
-
Hi,
When i do an export of queue details of december 2010, the first column is filled with the date. But Excel automatically adds a year to it, in this case the current year 2011 so the information is not correct.
Is there an option where you can do an export including the year so Excel doesn't make it 2011?
It's a custom export in the tab All from Queue details.
-
You could change the dateformat_short in queuemetrics_en_EN.properties so that a year is explicitly posted.
-
The settings are now like this:
dateformat_complete=MMMM dd yyyy, HH:mm
dateformat_date=yyyy-MM-dd
dateformat_completeshort=MM/dd - HH:mm:ss
dateformat_time=HH:mm:ss
dateformat_timeshort=HH:mm
dateformat_flow=1
Which one should i change?
-
I think it's
dateformat_completeshort=MM/dd - HH:mm:ss
Becaise that's the one that does not include the year.
In order to activate it, change the language (e.g. to German) and then change back to English.
-
I think it's
Code:
dateformat_completeshort=MM/dd - HH:mm:ss
Becaise that's the one that does not include the year.
In order to activate it, change the language (e.g. to German) and then change back to English.
Do i need to change it into:
dateformat_completeshort=MM/dd/YYYY - HH:mm:ss ?
And do i need to restart a process or is the change directly active after saving?
-
No, just logoff and on again, change the language (say to German) and back to English again.
-
It worked, thank you for the help!
-
;D