Error 8113

The date is not in an ISO-compliant format. Dates 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 Seattle should be expressed as:

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

The ISO standard is based on Greenwich Mean Time (GMT). If you're in the Pacific Time Zone, you are 8 hours off GMT (7 hours off GMT in Daylight Savings). This is indicated by the "-8:00" in the formula above. If you're in the Eastern Time Zone, you are 5 hours off GMT (4 hours off GMT in Daylight Savings).

One common reason why this error occurs is:

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

If you are using 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.