Comvert to a date when Day in text is included

  • Thread starter Thread starter rdemyan via AccessMonster.com
  • Start date Start date
R

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.
 
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
 
Back
Top