[AccessD] date conversion

[jack drawbridge]

Rocky,

Since you have the  12-Jun-2015, you don't really need the Fri

I tried this
Dim x As String
x = "Fri 12-JUN-2015"
Debug.Print CDate(Right(x, 11))

and it returns the short date
(I'm in Canada  [d/m/y], so I get 12/06/2015)
jack

On Wed, Jun 17, 2015 at 7:17 PM, Rocky Smolin <rockysmolin at bchacc.com>
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
>