[AccessD] date conversion

[Rocky Smolin]

Correct!  Thanks Jack.

R
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
jack drawbridge
Sent: Wednesday, June 17, 2015 4:42 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] date conversion

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