I am trying to pull information matching up my person table where we did a date conversion formula on it with a diagnosis table to give me the list of patients with the identified diagnosis but within a date range in the date of birth. we used this conversion (see below) based on a date that was a text field of a date. I tried to use the "text" format for the date as well as the normal date format but it gave me data missmatch error. How do I now work with this date format?
dbo_person.person_id, dbo_person.person_nbr, dbo_person.last_name, dbo_person.first_name, CDate(Left([dbo_person].[date_of_birth],4) & "-" & Mid([dbo_person].[date_of_birth],5,2) & "-" & Right([dbo_person].[date_of_birth],2)) AS date_of_birth
Thank you for all of your help
Patty
Posted by: pattykf@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar