Dylan,
Could it be a TIME ZONE issue on the mid tier either with the server or with the user's profile? Is that the only ticket resolved after 5pm on 5/31? Gp George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Monday, July 02, 2007 5:34 PM To: arslist@ARSLIST.ORG Subject: Mid Tier only, wrong date in results 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. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"