The DATE Data Type
When defining a field type as a DATE data type, you must consider the date settings specified from Windows Control Panel. These settings affect the format of the date field and impact validation of the date field as shown in the table.
The standard validation for DATE checks for the short date format. In addition, the standard validation does not allow dates earlier than 1930. To use a long date format (such as Tuesday, December 22, 1998) or a date earlier than 1930, you must update your validation scripts.
With this Windows regional setting: |
You can use this format for Validation: |
Notes: |
---|---|---|
mm/dd/yy |
Any date format |
|
m/dd/yy |
Any date format |
|
m/d/yyyy |
Any date format |
|
mm/dd/yyyy |
Any date format |
|
yy/mm/dd |
yy/mm/dd dd-mmm-yy yyyy-mm-dd |
Other formats could cause validation errors. |
yyyy-mm-dd |
yy/mm/dd dd-mmm-yy yyyy-mm-dd |
Other formats could cause validation errors. |
dd-mmm-yy |
yy/mm/dd dd-mmm-yy yyyy-mm-dd |
Other formats could cause validation errors. |