[AccessD] YYYYMMDD string to date

Neat!

On 9 Aug 2007 at 22:54, Michael R Mattys wrote:

> 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 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com