By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,341 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Hmmm, probs with Date field

P: n/a
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!RCDate,10)"
This now does not work for some reason
gives me the error
"undefined function in left function"

any help here please
Graham
Aug 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.auwrote in message
news:44**********************@news.optusnet.com.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!RCDate,10)"
This now does not work for some reason
gives me the error
"undefined function in left function"

any help here please
Graham


Aug 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.