[AccessD] YYYYMMDD string to date

Hi John,

This seems to work:
CDate(Format("20070119","####-##-##"))

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, August 09, 2007 10:06 PM
Subject: [AccessD] YYYYMMDD string to date


> Is there a neat way to change a string date in YYYYMMDD format to a date? 
> I
> can write a function to parse the pieces etc but wondered if there is just
> something built in to Access that will do it.  Cdate() does not like it.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com