[AccessD] character to date datatype conversion?

Hi Bridget,

maybe like this 
(someone probably knows a better way)

format(left("110403",2)& "/" &  _
mid("110403",3,2) & "/" & _
right("110403",2),"Short Date")

Michael R. Mattys
Try MattysMapLib for MapPoint at
www.mattysconsulting.com



----- Original Message ----- 
From: "Bridget Doran" <bridgetd at biostat.umn.edu>
To: <Accessd at databaseadvisors.com>
Sent: Monday, August 25, 2003 1:41 PM
Subject: [AccessD] character to date datatype conversion?


> Hello
> 
> Is it possible to convert a text field to a date field in Access2K?
> 
> eg > 110403 to 11/04/03
> 
> Thanks
> Bridget
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com