Darryl Collins
darryl at whittleconsulting.com.au
Sun Nov 25 22:58:54 CST 2012
Ummm... would just formatting the field to "YYYY/MM/DD" work for you? (it should, but I guess it depends how clean your string is). Once it is a date you can do what you like with it. Hth a bit Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, 26 November 2012 3:49 PM To: Access Developers discussion and problem solving Subject: [AccessD] String to Date Given a string of the form "2012/12/26", how can I turn it into a date? I want to test whether the given date-string falls within the range of a pair of actual dates. Is there a StrToDate() function or some equivalent? If need be, it won't take long to write one, but I before I begin I want to make sure I'm not reinventing something built-in or readily available. TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com