I have a user that runs an advanced query to get her results. The problem I'm seeing is that the same exact query run in the user tool gives different results then in the mid tier. I have a date/time field I put in called Resolved. The query she runs is 'Resolved' >= "6/1/2007" AND 'Resolved' < "7/01/2007" The user tool will return the correct results, the mid tier pulls up an extra one that has the Resolved field set to 5/31/2007 5:26:51 PM Is there something funky that happens with mid tier queries or did I find yet another mid tier bug?
------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"