Date format in custom fields export to excel
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?
2
votes
Andrew ODonnell
shared this idea