Does anyone know how the Date (not Date/Time displayed as Date Only) data is stored?
For instance, we know Date/Time fields (regardless of how they are displayed) are actually stored as Epoch/Unix time. Thanks in advance! Shawn Stonequist EMNS Inc. -----Original Message----- From: Michelle L [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 1:54 PM Subject: Re: DST - Leap Year Issue with Date Only fields Hi, Randy: Thank you for your response. But, we're already on ARS 6.3 Patch 23. Was there another patch to address this. Is this patch generally available or is it something that you have to specifically request. Thanks, Michelle Randy Simon <[EMAIL PROTECTED]> Sent by: "Action To Request System arslist@ARSLIST.ORG discussion cc list(ARSList)" <[EMAIL PROTECTED] Subject ORG> Re: DST - Leap Year Issue with Date Only fields 03/12/2008 11:30 AM Please respond to [EMAIL PROTECTED] RG If you are on ARS 6.3 there is a patch for this problem. We had the same problem, but we are on 6.0 and would need to upgrade to 6.3 and install the patch. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michelle L Sent: Wednesday, March 12, 2008 11:29 AM To: arslist@ARSLIST.ORG Subject: DST - Leap Year Issue with Date Only fields Hey Y'all: Remedy ARS 6.3 P23 (Server is in Central time zone) Windows 2003 SQL Server 2000 Admin tool ARS 6.3 P23 User Tool 6.3 P23 and 7.0.1 Patch 005 We're not sure if this issue is DST only related or DST and Leap Year related. We discovered an interesting phenomenon when we reviewed records in various forms with Date fields (not Date/Time). On March 9, 2008 starting at 3:00 AM and continuing through the remainder of the day, any Date field set with $DATE$ was set to March 8, 2008. It didn't matter what time of day it was. Date/Time fields were appropriately set to March 9, 2008 and current time. We had to update thousands of records in various forms. Did anyone who is still on Remedy ARS 6.3 experience this? Thanks, Michelle ====================================================================== Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential, is intended only for the use of the intended recipient, and is the property of Countrywide Financial Corporation or its affiliates and subsidiaries. If you are not the intended recipient, you are hereby notified that any use of the information contained in or transmitted with the communication or dissemination, distribution, or copying of this communication is strictly prohibited by law. If you have received this communication in error, please immediately return this communication to the sender and delete the original message and any copy of it in your possession. ====================================================================== ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ====================================================================== Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential, is intended only for the use of the intended recipient, and is the property of Countrywide Financial Corporation or its affiliates and subsidiaries. If you are not the intended recipient, you are hereby notified that any use of the information contained in or transmitted with the communication or dissemination, distribution, or copying of this communication is strictly prohibited by law. If you have received this communication in error, please immediately return this communication to the sender and delete the original message and any copy of it in your possession. ====================================================================== ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"