# of days since January 1, 4713 B.C., using a hybrid of the Julian and
Gregorian calendar systems (similar to the Oracle calendar -- see
http://www.orafaq.com/papers/dates_o.doc).
----- Original Message -----
From: "Shawn Stonequist" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <arslist@ARSLIST.ORG>
Sent: Wednesday, March 12, 2008 3:27 PM
Subject: Re: DST - Leap Year Issue with Date Only fields
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"