date fields?

[nikko50]

Hi ALL,
Do date fields always have a value of 000-00-00 when a new row is created? I ask this beacuse how can I test a date field to see if a value has been entered.

[devinemke]

that all depends on what you set the default value to be when you created the table. i typically use a default of NULL for date/time fields rather than 0's.

[nikko50]

Thanks so much. Will try that now!
Tracy