No Matches Found!
Try with a different search term
l.s. I know that you can change the 12/AM/PM settings to 24H via the preferences, but when I build
an report it still present as 12H AM/PM , how /where to change this?
(we in The Netherlands think in 24 hours, except the UK of course :-)
Hi Peter,
Thank you for posting in SOTI Central.
I've just sent a request to check if 24H format is available in reports. I'll get back to you in due course.
Regards,
Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |
Hi RRMOD,
Do you have any updates on this?
If you could also look into the date format along with the time.
I'm in UK and when looking at a report in Excel the date is rarely correctly formatted, even when using the Text to Columns function and choosing the matching date/time format.
I believe this is something to do with the way data is formatted in csv export:
Device Name,Agent Check-in Time,Battery Percentage,Available Memory,Path
DEVICE00001,2/24/2021 2:01:03 PM,5,1051213824,\\My Company
DEVICE00003,2/28/2021 8:08:58 AM,5,1271701504,\\My Company
DEVICE00006,3/17/2021 12:16:20 PM,20,1152577536,\\My Company
DEVICE00002,4/13/2021 1:43:50 PM,89,1236389888,\\My Company
DEVICE00005,4/13/2021 1:49:39 PM,96,1308119040,\\My Company
DEVICE00004,4/13/2021 2:27:50 PM,15,1216442368,\\My Company
DEVICE00007,4/13/2021 3:01:26 PM,3,1284145152,\\My Company
DEVICE00008,4/27/2021 2:04:48 PM,99,1117523968,\\My Company
DEVICE00009,4/28/2021 8:01:03 AM,5,1070895104,\\My Company
DEVICE00010,4/28/2021 1:42:04 PM,89,1071951872,\\My Company
DEVICE00011,4/30/2021 2:01:20 PM,6,1164255232,\\My Company
DEVICE00012,5/3/2021 2:01:03 AM,5,1324519424,\\My Company
Personally in an export I'd use a date/time like YYYY-MM-DD HH:mm:ss, also has the advantage that it can be sorted correctly as "text" rather than relying on being changed into a "date".
If you think this should be raised as a development ticket, please let me know.
Thanks,
Gary