Hi, Just deduct 28800 from your Start and End Dates when doing query on the web if you don't want the Mid-Tier to auto-adjust the time to GMT:
'Create Date' >= ("10/01/2007 00:00:00 AM" - 28800) AND 'Create Date'
< ("11/01/2007 00:00:00 AM" - 28800)
Cheers!
~ Eli ~
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
