Skip to main content

Changing Operating System Date and Time Formats for Imports

Updated

In order to import and export data that contains dates and/or times into vintrace, you’ll need to ensure that the date and time formats in your operating system have leading zeros.

Mac OS: Ventura and Newer

These steps apply to Ventura and onward. If you are using a Mac OS prior to Ventura, refer to Mac OS: Prior to Ventura. You can also refer to Apple’s site for information. 

To change the date and time format on Mac operating systems Ventura or newer:

    1. Click the Apple icon that’s located in the upper left.
    2. Click System Settings.
    3. From the menu on the left, click General.
    4. Change the date format by doing the following:
    • Click Language & Region.

Mac Newer OS - General - Language Region 20241024.png

    • Change the Date Format to include leading zeros. 

Mac Newer OS - Date Format 20241024.png

  1. Ensure the time format is using 24-hour time by doing the following:
    • From the General list of the system settings, click Date & Time.
    • Ensure that 24-Hour Time is enabled.

Mac Newer OS - 24 Hour Time 20241024.png

  1. Close the system settings window.

The date and time format changes are not applied to previously exported CSV files.

Mac OS: Prior to Ventura

These steps apply to Mac OS prior to Ventura. If you are using Mac OS Ventura or newer, refer to Mac OS: Ventura and Newer. You can also refer to Apple’s site for information. 

To change the date and time format on Mac operating systems prior to Ventura:

  1. Click the Apple icon that’s located in the upper left.
  2. Click System Settings.
  3. Click Language & Region.
  4. Click Advanced.

Mac Older OS - Language Region - Advanced Button 20241024.png

  1. Change the date format by doing the following:
  • Click Dates.
  • Set the Short Date to your local format including leading zeros.

Mac Older OS - Dates Short 20241024.png

  1. Ensure the time format includes leading zeros by doing the following:
  • Click Times.
  • Set the Short Time format to include leading zeros.

Mac Older OS - Times Short 20241024.png

  1. Click OK.

The date and time format changes are not applied to previously exported CSV files.

Windows 11

These steps apply to Windows 11. If you are using Windows 10, refer to Windows 10. You can also refer to Microsoft's site for information.

To change the date and time format in Windows 11:

  1. Click the Windows Start button.
  2. Click Settings, or search for Settings if it’s not visible.
  3. Click Time & Language.
  4. Click Regional Format.
  5. Click Change Formats.

Windows 11 - Change Format Button 20241024.png

  1. Change the Short Date and Short Time to include leading zeros.
  2. Close the Settings window.

The date and time format changes are not applied to previously exported CSV files.

Windows 10

These steps apply to Windows 10. If you are using Windows 11, refer to Windows 11. You can also refer to Microsoft's site for information.

To change the date and time format in Windows 10:

  1. Click the Windows Start button.
  2. Click Settings, or search for Settings if it’s not visible.
  3. Click Time & Language.

Windows 10 - Settings - Time and Language 20241024.png

  1. Click Region.
  2. Click Change Data Formats.

Windows 10 - Change Data Formats 20241024.png

  1. Change the Short Date and Short Time to include leading zeros.
  2. Close the Settings window.

The date and time format changes are not applied to previously exported CSV files.

Powered by Zendesk