[AccessD] String to Date

Thanks, all. I had a sneaking suspicion that there was something like
CDate(). Just the little sucker I was fishing for!

A.


On Mon, Nov 26, 2012 at 7:50 AM, jack drawbridge <jackandpat.d at gmail.com>wrote:

> CDate should work.
> http://www.techonthenet.com/access/functions/datatype/cdate.php
>
> On Mon, Nov 26, 2012 at 2:52 AM, Paul Hartland <
> paul.hartland at googlemail.com
> > wrote:
>
> > You may of tried this, but couldn't you declare a variable as a date and
> > then pass the date string into it, then check if the date variable is
> > between the date range ?
> >
> > Paul
> >
> > On 26 November 2012 06:41, Stuart McLachlan <stuart at lexacorp.com.pg>
> > wrote:
> >
> > > Nope, that just returns True/False - in this case, True
> > >
> > > --
> > > Stuart
> > >
> > > On 25 Nov 2012 at 21:45, Rocky Smolin wrote:
> > >
> > > > WAG:  would IsDate function do it?
> > > >
> > > > Rocky
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > -----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
> > > >
> > > >
> > > >
> > > > --
> > > > 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
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> >
> > --
> > Paul Hartland
> > paul.hartland at googlemail.com
> > --
> > 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
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr