Couldn't you use something like error message if 'End Date' <= $DATE$ or if 
'End Date' <= $TIMESTAMP$. This could be done with either an active link or a 
filter depending on when you want to catch the error.

Good Luck
Mark

________________________________
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Reiser, John J
Sent: Tuesday, December 22, 2009 3:24 PM
To: [email protected]
Subject: Epoch time rollover issue for dates past 2037

Hello Listers,
ARS 7.1 Patch 004
MS SQL 2005

We have a need to record an end date greater than 2037 and the Date/Time fields 
are restricted by the 32 bit integer of Epoch Time.
I prefer to avoid Date only fields because of the widget and the BC check box.
Do Date only fields cause any workflow headaches? I will probably need to check 
End Dates against the current date when records are entered and retrieved.
Example. Don't let a date be set in the past. Lock out changes to a record if 
the End Date has passed when the record is opened. Etc.
Just looking for a sanity check. Is there a better work around like formatting 
the date to a character field (YYYYMMDD) or do I just use the Date only because 
"it's fully supported by BMC and it was designed to address this type of issue."

Merry Christmas to all.
Thanks,
---
John J. Reiser
Senior Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to