[AccessD] String to Date

CDate("2012/12/26") will do it. It recognises that as a valid date format.

As does Format("2012/12/26","d mmm yyyy")    :-)

-- 
Stuart

On 25 Nov 2012 at 23:48, Arthur Fuller wrote:

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