[AccessD] String to Date

Yep, that works too - because of intrinsic conversions:

Function test()
Dim str As String
Dim dt As Date
str = "2012/12/26"
dt = str
MsgBox dt
End Function

-- 
Stuart

On 26 Nov 2012 at 7:52, Paul Hartland 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
>