Date function in Access

[SBO]

I have accidently used the name date in one of my table fields. When I tried to use the date funtion later down the track Access refered to the date used in one of my table field.

I have changed the table field to datein, however when I try to use the date function access is comes up with an error, telling me it can't find the field date refered to in the expression.

I have been able to get around the problem by using the now function. Does anyone know how to reset the function so when I use date it won't go looking for a field in a table??

Hi SBO,

I don't know if this will help, but try:

http://www.techonthenet.com/access/functions/date/format.htm

Or

http://www.techonthenet.com/access/functions/date/date.htm

[vivekar]

You need to change the sql query to reflect the change of field name from "date" to "datein".