Exported Date format

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
  • March 17, 2016 at 1:33 PM #16117

    Carol Moncrief
    Participant

    When I export records, I set the date format to MM/dd/yyyy (see attached). But in the exported file the date field is in the format 1927-12-14, with the year displayed first. What settings are required to export the date field MM/dd/yyyy? Thanks!

    Attachments:
    You must be logged in to view attached files.
    March 17, 2016 at 3:11 PM #16122

    Brendan
    Keymaster

    Hi Carol,

    Use the CSV export instead of the XLSX export. It may be a setting in Excel after you import that’s changing the format.

    Thanks,

    Brendan

    March 17, 2016 at 8:02 PM #16124

    Carol Moncrief
    Participant

    Yes! That works. Thanks!

Viewing 2 reply threads

You must be logged in to reply to this topic.