S
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
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