Date and Time Format Requirements for Import

Overview

To ensure dates and times from your .csv file are imported correctly into the Big Table, you must use one of the accepted formats listed below. Import Rx supports several common formats.

Supported Date Formats

• MM/DD/YYYY: (e.g., 07/15/2025)
• MM-DD-YYYY: (e.g., 07-15-2025)
• YYYY-MM-DD: (e.g., 2025-07-15)
• YYYY/MM/DD: (e.g., 2025/07/15)
• MMDDYYYY: (e.g., 07152025)
• MMDDYY: (e.g., 071525)
• MM/DD/YY: (e.g., 07/15/25)

Accepted Date and Time Formats

For fields that include both a date and a time:

• YYYY-MM-DD HH:mm:ss: (e.g., 2023-09-17 18:00:00)

Location-Specific Formats

The system also supports specific date formats based on the selected user locale:

• English (United States): MM/DD/YYYY
• Spanish (Spain) & Spanish (Mexico): dd/MM/yyyy
• Turkish (Turkiye): dd.MM.yyyy
• English (Canada): yyyy-MM-dd