Thread: Convert Text field to Date field within existing database
View Single Post
  #2  
Old December 21st, 2008, 02:04 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
  
Posts: 2,364
Default Convert Text field to Date field within existing database
To get just the date part you could use

CDate(Format(Left("24APR2008:14:12:17",9),"@@ @@@ @@@@"))