Error 6000: Date Format Error

Date must be in the format YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS(((+|-)HH:MM)|Z).

This error occurs when you provide dates that are not in the standard ISO-compliant format.

As an example, February 29, 2008, 1:10:30 p.m. in London should be expressed as:

• 2008-02-29T13:10:30+0:00
• OR simply: 2008-02-29

The ISO standard is based on Greenwich Mean Time (GMT). If you're in Mainland Europe, you are 1 hour ahead of GMT. This would be indicated by "+1:00" in the formula above.

One common reason why this error occurs is:

• You entered the date correctly in a Microsoft-Excel--based template and Microsoft Excel reformatted your date.

If you are using Microsoft Excel to manage your data, you can format your date columns as text to prevent Excel from automatically reformatting them. To do this:

1. Go to the Format tool on the shortcut menu and choose "Cells."
2. On the Number tab, select "Date."
3. Choose "Text" to format numbers as text.