Comvert to a date when Day in text is included

[rdemyan via AccessMonster.com]

How do I convert the following to a date using something like CDate

Wednesday, March 22, 2006

I keep getting errors.

Thanks.

 

[TC]

If you know for certain, that every date will always begin with the
day-name and then a comma - just take evrything after the first comma:

(untested)

dim s as string
s = "Wednesday, March 22, 2006"
....
? CDate (mid$ (s, instr(s, ",")+1))

HTH,
TC (MVP Access)
http://tc2.atspace.com