Thanks. I'll give that a shot because I don't really care about the actual time on these dates anyway.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer 1300 Main St. Houston, TX 77002 | 713.989.7226 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Friday, January 03, 2014 11:04 PM To: [email protected] Subject: Re: View Form Issue with Date Field and Epoch Time ** Shawn, What you will need to do is convert it to a Date instead of a Date/Time field if you want to handle before 1970. You will loose fidelity of time of day, but will be able to handle any date you will encounter On Jan 3, 2014 9:45 PM, "Pierson, Shawn" <[email protected]<mailto:[email protected]>> wrote: ** Good afternoon, I think I've found a limitation in View Forms that is causing some issues. Basically, for the integration I built with HR data, I'm seeing errors when converting dates for people hired prior to 1970. There aren't any active folks like this, but it seems to be causing issues with my Escalation that double checks that these people, who may have left the company decades ago, no longer have a People record (despite the fact that none would have ever been created.) I've been planning on resolving this by filtering the data to only include records where the termination date is null or where the termination date happened in the past month. However, I am curious, how do we make Remedy handle dates prior to 1/1/1970 if the need arises in the future? Thanks, Shawn Pierson Remedy Developer | Energy Transfer Private and confidential as detailed here<http://www.energytransfer.com/mail_disclaimer.aspx>. If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
