Gustav Brock
Gustav at cactus.dk
Thu Mar 30 12:18:00 CST 2006
Hi A.D. That may not work as the literal month names are localized as well. /gustav >>> adtp at airtelbroadband.in 30-03-2006 20:04 >>> StrSQL = StrSQL & " WHERE TDate Between #" & _ Format(StartDate, "dd-mmm-yyyy") & "#"