[AccessD] Dates As Criteria

Mark A Matte markamatte at hotmail.com
Wed Feb 14 10:16:16 CST 2007


Thanks Gustav,

FIX works.  I only posted this yesterday...but do you know the subject of 
the thread containing Arthur's advice?

Thanks,

Mark A. Matte


>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 16:57:20 +0100
>
>Hi Mark
>
>The quick way to remove the time portion is to use Fix:
>
>   WHERE Fix(ArrestDT) Between
>
>The advice from Arthur about using static functions is a couple of days 
>old.
>
>/gustav
>
> >>> markamatte at hotmail.com 14-02-2007 16:46:08 >>>
>I set the parameters...no change...and the reason I I use the format
>function is that the field ArrestDT is stored as a general date...with 
>time.
>   So I format to get just the short date.
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Valentine’s Day -- Shop for gifts that spell L-O-V-E at MSN Shopping 
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline




More information about the AccessD mailing list