Date Values

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

Fields

String Values

Default and Null Values

Binary Values

Integer Fields as References

Integer Fields as Table IDs

Next

Binary Values

Date Values