Default date value

[indra]

Does anyone know why I cannot set default value on a field named: status_date.
I have a table with 4 date fields. I can use dbEditFlds to set default value (system date) on all date fields except one with status_date. Is this a keyword in aspdb?
Please Help!

[John]

Hi Indra,

I don't think it's an ASPdb thing, but I do know that 'date' is, and fields that start with underscore are also. Try changing the field name to status_dt and see if that fixes it?

Thanks,
John


------------
indra at 2/15/2002 7:03:52 PM


Does anyone know why I cannot set default value on a field named: status_date.
I have a table with 4 date fields. I can use dbEditFlds to set default value (system date) on all date fields except one with status_date. Is this a keyword in aspdb?
Please Help!