[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://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=hmtagline