[AccessD] Dates As Criteria

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