Microsoft, Access, 2003, convert 19970519 text to date format

I am trying to covert the following text field 19970519 to a date field in Access 2003. This text field is in YYYYMMDD.
VFtechnologyAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
cdate(mid("19970519",5,2)&"/"& mid("19970519",7,2)&"/"&left("19970519",4))

or

cdate(mid([datefield],5,2)&"/"& mid([datefield],7,2)&"/"&left([datefield],4))
0
 
rockiroadsCommented:
something like this perhaps

mydatefield = dateserial(left$(mytextfield,4), mid$(mytextfield,5,2), right$(mytxtfield,2))

0
 
rockiroadsCommented:
VFtechnology
just out of interest, did dateserial not work for you? be interested to know where its failings with regards to your code
0
All Courses

From novice to tech pro — start learning today.