Tony, AHHH she's on a 6.x, that might explain why it works for her. But yea, what you wrote below is the exact same thing I saw.
I've upgraded our Mid-Tier now to 7.0.01 to see what the results are, and I'm about to ask David Easter on the ARS List What version of the User tool is DST compliant, as I was using 7.0.00 Patch 1, and the doc he sent is for 7.0.01. I've got a few things I want to try and see if they make any differences. I'll let yea know what I find and if I come up with a solution. Thanks, Matt -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 10:36 AM To: arslist@ARSLIST.ORG; Matthew Perrault Subject: Re: DST Date/Time in a Table field on the Web Error Matthew - I'm guessing our issue is unique to a v7 server, as Michelle is on v6 ARS. I didn't have any TZ preference set. Just verified using another user account viewing the same data in Mid-Tier as in ARS and see the missing one hour on the web. The time/date fields are wrong in the results list, table fields and form. After setting my timezone in the preference form to to America/Chicago CST the dates (table/column/results) in mid-tier are correct. Hum... -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Matthew Perrault <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 03/23/2007 04:09 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: DST Date/Time in a Table field on the Web Error Michelle, Thanks for the info, but that's not quite it. It's not a difference in the Results List and the Fields in the Form. It's the difference between what is shown in the USER tool and what is shown on the Web Pages. The other question I have is to take a look at your AR System User Preferences form. Do you have a Time Zone specified under the Locale tab? If you do Clear it, Clear you IE cache, and then re-display the web pages. Do you get the same results? Thanks Matt -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST contractor Sent: Friday, March 23, 2007 3:57 PM To: arslist@ARSLIST.ORG Subject: Re: DST Date/Time in a Table field on the Web Error If I understand you correctly, the issue is that there is a 1 hour difference between a date/time field on the form and the same field as displayed in the Results list. If so, we are not having this issue on Mid-Tier 7.0.01 Patch 1. This is a full windows 2003 environment with all windows patches applied. We didn't have to update any preferences, etc. Our environment is a little different. Mid-Tier 7.0.01 Patch 1 (Windows 2003/IIS 6/Java 1.6/Apache Tomcat 5.5) ARS 6.3 Patch 21 (Windows 2003/Remote SQL Server 2000) AR User 7.0.01 Patch 1 I had seen posts earlier this month regarding certain time zones. Something about a timezone record was missing or incorrect. We're in the US CDT zone. Hope that helps, Michelle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Perrault Sent: Friday, March 23, 2007 12:21 PM To: arslist@ARSLIST.ORG Subject: DST Date/Time in a Table field on the Web Error All, Environment: AR User: 7.0.00 Patch 001 AR Server: 7.0.01 Patch 001 200701111654 Mid-Tier: 7.0.00 Patch 001 200605201549 Java JRE: 1.4.2 Patch 13 IIS Windows 2K MS-SQL Ok, I've got a Join-form with a Date/Time field on it. I created a record on one of the base forms after the DST change/patches. When I open the Form in the User too, the Date/Time field shows the correct time. Yet when I open the Join Form on the Web the Date/Time field in the Results List table at the top shows the time off by an hour (1 Hour back). For Example the value in the field on the base form as well as the Join-form, when opened in the User Tool shows: 3/16/2007 10:32:44 AM When opened in the Web, the Column in the Results List table field shows: 3/16/2007 9:32:44 AM I've checked the Registry entries on the Server and they look good. The Mid-Tier runs on the same server as the ARS Service and the time on the Server looks good. The Server team has patched the Server as well. We've tested the Java Engine, and that appears ok, and DST compliant. I have added my TimeZone to my User Preferences, taken it off and that did not make any difference. The strange thing is, that records that were created before the DST time change show the correct Date/Time in both the User and Web. Records created AFTER the DST patch show the time off by an hour. The Mid-Tier and AR Server are both in the same time-zone as I am. So my questions are: 1) What could be causing this? 2) Is anyone else experiencing this? 3) Any Suggestions on how to fix this or where to look? Thanks, Matt ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
