Re: Epoch time rollover issue for dates past 2037

2009-12-28 Thread Kemes, Lisa
, December 23, 2009 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: Epoch time rollover issue for dates past 2037 @Matt, I'm probably going to build a Dialog that lets them select the date they need, store it as a DATE field for workflow and display YYYMMDD (at the request of the user). My RFE

Re: Epoch time rollover issue for dates past 2037

2009-12-28 Thread Kemes, Lisa
@ARSLIST.ORG Subject: Re: Epoch time rollover issue for dates past 2037 Weird, I'm running into the EXACT same issue. I need to delete records that are 6 years old, so I added a Date/Time field (hidden) and added 6 years to the Expiration Date and set my hidden Date/Time field to this date. Problem

Re: Epoch time rollover issue for dates past 2037

2009-12-28 Thread Grooms, Frederick W
, Lisa Sent: Monday, December 28, 2009 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Epoch time rollover issue for dates past 2037 Weird, I'm running into the EXACT same issue. I need to delete records that are 6 years old, so I added a Date/Time field (hidden) and added 6 years

Re: Epoch time rollover issue for dates past 2037

2009-12-28 Thread Kemes, Lisa
@ARSLIST.ORG Subject: Re: Epoch time rollover issue for dates past 2037 Your hidden field is a Date field? Try the following In a Filter (or AL) Action 1: Set you hidden Date field to: DATEADD( , 6, DATE($Expiration Date$)) Fred -Original Message- From: Action Request System

Re: Epoch time rollover issue for dates past 2037

2009-12-23 Thread Carey Matthew Black
John, Given all that you said I would suggest that you do all of the following: 1) Use a UI that you build ( if you do not like the default UI ) A display only dialog, called from a custom button and suppress the OOB UI for the field. If you have to ... go all the way to a DVF for a

Re: Epoch time rollover issue for dates past 2037

2009-12-23 Thread Reiser, John J
brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Wednesday, December 23, 2009 9:14 AM To: arslist@ARSLIST.ORG Subject: Re: Epoch time rollover issue for dates past 2037

Epoch time rollover issue for dates past 2037

2009-12-22 Thread Reiser, John J
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

Re: Epoch time rollover issue for dates past 2037

2009-12-22 Thread Brittain, Mark
list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Tuesday, December 22, 2009 3:24 PM To: arslist@ARSLIST.ORG 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