Henryk
Posts: 63
|
| Posted: 04/15/2005, 7:07 AM |
|
I have a date field I would like to update automatically whenever a record is updated, using the currentdatetime. I have tried clearing the value in the before show event, then setting the value in the hidden to currentdatetime. Clearing value and setting db field to default value of getdate() (only works on inserts), instead of clearing the value changing it to
xxx.value= date
xxx.value= date/time
those give me a sql non compatible format error for the date.
Any other suggestions?
Thanks!!!
|
 |
 |
Henryk
Posts: 63
|
| Posted: 04/15/2005, 7:44 AM |
|
NM, I used the now() in place of date and date/time and it works like a charm.
|
|
|
|
dhodgdon
Posts: 80
|
| Posted: 04/15/2005, 7:46 AM |
|
I do this with both visible and hidden controls by putting:
xxx.value = now()
as a code entry in the Before Execute Update event.
_________________
Regards,
David Hodgdon
|
|
|
|
|
