Date format in custom fields on Auditor export
On an agent you can choose a date format for a custom field, which works great. However when you run the Auditor report and it includes this field, Excel can't sort by the dates because it doesn't recognise the format.
Please can you change the date format into something Excel can easily recognise? Thanks in advance :)
Brendan Richman
shared this idea
Hi,
Thank you for your valuable suggestion. While we won't be implementing this idea in the immediate future, it has been added to our list for future consideration and we understand the relevance of your request.
We continuously review user feedback to inform our development priorities, so your idea remains on our radar.
Best regards,
The Atera Team
-
Brendan Richman
commented
Even better YYYY/MM/DD (ISO 8601) format :)
-
Scott Craig
commented
Id like to be able to download my reports in Excel but have the dates in DD/MM/YYYY
-
Andrew ODonnell
commented
I have used the custom field to add 'date purchased' and 'Warranty End Date' to my devices. However, it is inputted as a text field (Date field selected and you select the date from drop down menu). So when exporting Auditor reports to excel, the data is text and not date format and not usable to sort/search devices. This is used to monitor asset refresh and warranty expiration. Can Date field be change to a usable format for export?
-
Stuart Anderson
commented
Change the Last Seen format in the Audit Report to a more Excell friendly format ie dd/mm/yy time.