467,075 Members | 937 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

Hmmm, probs with Date field

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
  • viewed: 1529
Share:
1 Reply
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.

Similar topics

7 posts views Thread by vnl | last post: by
10 posts views Thread by Kenneth | last post: by
2 posts views Thread by andrewcw | last post: by
4 posts views Thread by Vishal | last post: by
7 posts views Thread by sheri@mbproducts.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.