Export Dates in Excel Friendly Format

Idea created by Jacquelyn Lane on Apr 5, 2017
    Active
    Score25
    • Arpad Szabo
    • Manjeet Kaur
    • Jacquelyn Lane
    • KateLloyd
    • Mike Cartwright

    When I export an Excel with a date/time field, the format is DD/MM/YYYY 00:00pm. This is not an Excel compatible format, so you cannot sort dates chronologically. To get around this, I have to use text-to-columns to remove the time portion of the field. Once the time is removed, it becomes sortable. 

     

    Please can the export format be adjusted so that Excel knows it's a date?