Room Reservations Import Error on Date/Time Format

Source: https://platform-support.certain.com/hc/en-us/articles/360019249853-Room-Reservations-Import-Error-on-Date-Time-Format

Published: 2026-01-21

Keywords: Room Reservations, Date/Time Format, Import, Excel, CSV, MM/dd/yyyy, mm/dd/yyyy

Document ID: https://platform-support.certain.com/hc/en-us/articles/360019249853-Room-Reservations-Import-Error-on-Date-Time-Format#split1

Overview

When importing Room Reservations, you may receive the following error on the date/time format.

Errors were generated for the following Records: Row: [x] - date of arrival should be in format "MM/dd/yyyy".

If you receive this error, try modifying the date/time format in the excel file used for import.

Open the .CSV file in Excel.
Go to the Arrival and Departure date column.
Modify the Arrival Date & Departure Date column format to be set to Custom: mm/dd/yyyy.