[AccessD] Dates As Criteria

Or just use DateValue([ArrestDT])

GK

On 2/14/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> AFAIK, Format ALWAYS returns a string data type.  It is just that the
> information in that string may be a valid date, time, currency etc.  IOW if
> you then fed that to cDate(Format(SomeDate,"ShortDate")) cDate would receive
> a string that is truly a date and can be converted.
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Wednesday, February 14, 2007 2:26 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Dates As Criteria
>
>
> Thanks Gustav,
>
> I thought If I used Format(ArrestDT,"Short Date") it would be a date...and
> not a string?  Am I confused?
>
> Thanks,
>
> Mark
>
> >From: "Gustav Brock" <Gustav at cactus.dk>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: <accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] Dates As Criteria
> >Date: Wed, 14 Feb 2007 20:12:18 +0100
> >
> >Hi Mark
> >
> >As Lambert wrote, just using Format leaves you with a string not a date.
> >If you have to - and I can't see that's the case here - you must use a
> >US formatted string expression for a date value:
> >
> >SELECT Format([ArrestDT],"\#m\/d\/yyyy\#") ..
> >
> >/gustav
> >
> > >>> markamatte at hotmail.com 14-02-2007 19:54:03 >>>
> >Thanks Jim...but that would cause a Circular Reference...I think??? And
> >if I named ArrestDT something else...we are back to where I
> >started...not returning the results I wanted.  This does disturb me a
> >little be cause I've used FORMAT(DT_Field,"Short Date") a thousands of
> >times...and never had this issue.  Using FIX does seem to 'fix' the
> >problem...lol...I'm still confused...but ok.
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> Laugh, share and connect with Windows Live Messenger
> http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://ima
> gine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=hmtagline
>
> --
> 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
>


-- 
Gary Kjos
garykjos at gmail.com