Patty,
I can't determine what was suggested since the previous email in the thread is not included in your email.
I expect the issue is with the Mid (dbo_person, 2) section. Mid() typically should have 3 arguments rather than 2.
I am seeing extra spaces after Left and Mid which shouldn't be there.
Is dbo_person a text/string field? Since you are expected a date, is it really dbo or is it dob (date of birth)?
Duane Hookom MVP
MS Access
I can't determine what was suggested since the previous email in the thread is not included in your email.
I expect the issue is with the Mid (dbo_person, 2) section. Mid() typically should have 3 arguments rather than 2.
I am seeing extra spaces after Left and Mid which shouldn't be there.
Is dbo_person a text/string field? Since you are expected a date, is it really dbo or is it dob (date of birth)?
Duane Hookom MVP
MS Access
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 30 Jan 2015 08:02:12 -0800
> Subject: Re: [MS_AccessPros] Date question
>
> I typed the following but getting error message. Can you help me find problem?
>
> RecDate: CDate(Left (dbo_person, 4), & "-" & Mid (dbo_person, 2) & "-" & Right(dbo_person, 2))
>
> Error says the expression you entered has an invalid . (Dot) or ! operator or invalid parenthesis
>
> Thank you so much
>
> ------------------------------------
> Posted by: pattykf@cox.net
> ------------------------------------
> Date: Fri, 30 Jan 2015 08:02:12 -0800
> Subject: Re: [MS_AccessPros] Date question
>
> I typed the following but getting error message. Can you help me find problem?
>
> RecDate: CDate(Left (dbo_person, 4), & "-" & Mid (dbo_person, 2) & "-" & Right(dbo_person, 2))
>
> Error says the expression you entered has an invalid . (Dot) or ! operator or invalid parenthesis
>
> Thank you so much
>
> ------------------------------------
> Posted by: pattykf@cox.net
> ------------------------------------
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar