To assign a date value to a field, use this form:
<field> =
DATE "<date value>";
The <date value> can be a string or the word NOW. For example:
creation_date =
DATE "1/1/99 08:00:00";
creation_date =
DATE NOW;
If the <date value> is set to NOW, the field will be set to the current date. To specify the earliest possible database date, enter ?/?/? ?:?:? in quotes for the <date value>. To specify the latest possible date, enter */*/* *:*:* in quotes for the <date value>. The default is the earliest possible date.
See Also |
Next |