[AccessD] date conversion

[Steve Schapel]

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