[AccessD] date conversion

[Stuart McLachlan]

Datevalue doesn't like the ddd part so you need to strip it.  This works:

Format(datevalue(mid$("Fri 12-JUN-2015",5)),"mm/dd/yyyy")



On 17 Jun 2015 at 16:17, Rocky Smolin wrote:

> Dear List:
> 
> Access 2003 - VBA
> 
> Is there a function that will convert a date in a text box formatted
> ddd d-mmm-yyyy (Fri 12-JUN-2015) to short date (mm/dd/yyyy) format?
> 
> MTIA
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> Skype: rocky.smolin
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>