4 bytes
Up to 10
None
Stores and displays a date. The date is entered in MMDDYYYY form and is displayed according to the system settings, in short form. The year values can range from 1800 to 9999. You can use the calendar drop-down in the field to select a date.
Dexterity automatically checks each date value to ascertain whether its values are within the acceptable ranges of a date value. If the date is not valid, a message is displayed.
If only two digits are entered in the date field, the month and year will be defaulted. If the date field previously contained a value, the month and year from the previous value will be used. If the date field was empty, the month and year from the current system date will be used.
If only four digits are entered in the date field, the year will be defaulted. If the date field previously contained a value, the year from the previous value will be used. If the date field was empty, the year from the current system date will be used.
If only six digits are entered in the date field, the century will be defaulted. Dates entered with year values 36 to 99 have 1900 as the default century value. Dates with year values from 0 to 35 have 2000 as the default century value.
An uninitialized date field (one that hasn’t been set to a value) will have the value 00000000. Dexterity allows this as an acceptable date value.