Convert Last Seen Date/Time in Audit report to just Date

dean.barnard
Member Posts: 1 ✭
in Reporting
When I use the Audit to export all of a customers machines, I want to the sort it by the Last Seen Date in Excel, but because the format is similar to October 21, 2024 9:15:10 AM it always sorts as a text field. Excel doesn't recogize it as a date field (even if I say 'Format as date'). I had put this is a feature request but assume that it's not high on the list. The only way I've found to get round this is copy it to a Google Sheets Spreadsheet and covert it (which it does quite happily) and copy it back.
Has any one managed to easily covert it to a date in Excel itself?
Thanks
Dean
Tagged:
0
Topics
- All Topics
- 60 Getting started
- 27 Read before posting
- 9 Meet and greet
- 314 General
- 74 News and announcements
- 2 Swag
- 5 Roadmap updates
- 1 Product Survey
- 92 Resources
- 16 Knowledge Base
- 18 Webinars
- 1 Shared Script Library
- 3 Blog
- 22 Pro Tips
- 30 Got an idea?
- 3 Atera Academy
- 7 ActionAI
- 4 Copilot
- 217 Remote Monitoring and Management
- 88 Remote Monitoring
- 29 Patch Management
- 118 Professional Services Automation
- 70 Helpdesk
- 18 Billing
- 24 Reporting
- 43 Integrations & add-ons
- 23 Integrations
- 11 Add-ons
- 113 Scripting and automations
- 62 Scripts
- 36 Automations