Hmmm, probs with Date field

[Graham Feeley]

I have a date field named rcdate
it is a general date eg:
12/08/2006 3:30:00 PM
12/08/2006 3:00:00 PM
I used to update another empty field named rdate with the
with using in a update query " Left(Ratings!RC Date,10)"
This now does not work for some reason
gives me the error
"undefined function in left function"

any help here please
Graham

[Larry Linson]

The Left function works on Strings or Text Fields. Date/Time Fields are
neither, and what you show is the _formatted_ date/time from a Date/Time
Field.

If the Field whose value you want to set from the Date/Time is a Text Field,
look into using the Format function to format the Date/Time before
extracting the first ten characters with Left, or, even better just format
only the date portion.

If the Field whose value you want to set to just the date portion of the
Date/Time is itself a Date/Time Field, look in Help at various Date/Time
manipulation functions, e.g., Date Part, Date Serial, Month, Day, Year, etc.

Larry Linson
Microsoft Access MVP
"Graham Feeley" <gr***********@ optusnet.com.au wrote in message
news:44******** **************@ news.optusnet.c om.au...

>I have a date field named rcdate
it is a general date eg:
12/08/2006 3:30:00 PM
12/08/2006 3:00:00 PM
I used to update another empty field named rdate with the
with using in a update query " Left(Ratings!RC Date,10)"
This now does not work for some reason
gives me the error
"undefined function in left function"

any help here please
Graham