Help! The format of the date/time column on the Reservation Import is wrong?

Modified on Tue, 3 Mar at 1:09 AM

Are you attempting to upload reservations to your Reserve, but are running into the following error in your upload report?

The Start Time entered is not in the correct format.

This can be caused by Excel automatically formatting the date/time cell in the Reservation Import template .CSV file. To avoid this, make sure to format the cell as "text" rather than "date" or "custom" in the template.

The syntax for the date/time columns must be as follows:

  • 2021-01-30 18:00 (year-month-day 24 hour time)

Once saved, try uploading again. If the text format saved correctly, your upload should be successful!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article