[AccessD] date conversion

[Stuart McLachlan]

Good point.  

If it is an actual date field in a textbox, explicitly use  txtSomeDate.Value rather than 
txtSomeDate  or txtSomeDate.Text 



On 18 Jun 2015 at 11:57, Steve Schapel wrote:

> 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
>