date stamp

[steve a]

Hi
Im' trying toadd a date stamp into a field through an afterupdate of an
option box,
i've been using the code
me.[dstamp] = date()

but when entered the () disapears, so it reads

me.[dstamp] = date

and i get the error message
"cant find field "date" reffered to in your expression."

the = now() command fine, and this returns the correct d/t, however i also
need just the date, to use for a comparrison in a query, so if there's a way
of removing the time from a d/t stamp in a query that would also work.
however i need to keep the complete d/t stamp in the database for other
reports.
any idea's people?
Many thanks
Steve

 

[bismuth83]

You can try saving the entire date/time using Now(), and when you run
your comparison query, use the expression Format([datefield],Date) to
compare using only the date.