[AccessD] String to Date

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





More information about the AccessD mailing list