[AccessD] date conversion

[Rocky Smolin]

Well it's an unbound text box.

R
 

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

Hi Rocky

When you say "date in a text box", if it's a date then it's a date, and
doesn't need conversion, just change the format.  Or do you mean it is a
Text data type?

Regards
Steve

-----Original Message-----
From: Rocky Smolin
Sent: Thursday, June 18, 2015 11:17 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] date conversion

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