paul.hartland at fsmail.net
paul.hartland at fsmail.net
Sat Apr 19 13:50:06 CDT 2003
Pedro, You could try something like this : MyDateField = Format(Right(MyTextDate,2) & "/" & Mid(MyTextDate,5,2) & "/" & Left(MyTextDate,4), "DD/MM/YYYY") Watch out for line wrapping.... Paul From: "Pedro Janssen" <pedro at plex.nl> Date: Sat 19/Apr/2003 18:32 GMT To: <AccessD at databaseadvisors.com> Subject: [AccessD] convert text into date Hello Group, how can i convert a text field (20001201) into a date field (01-12-2000) TIA Pedro Janssen _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com __________________________________________________________________________ Join Freeserve http://www.freeserve.com/time/ Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.