Gustav Brock
Gustav at cactus.dk
Wed Feb 14 09:57:20 CST 2007
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.