Ah, well then that would be a problem. You could
display the DDMMYY elements as discrete integer fields
(or drop-down lists) or as a single character field, but data
validation and enforcing a single format might be difficult on that. But
if you're upgrading anyway, it might not be worth re-doing not only the code,
but the data, once you upgrade and can use Date fields. That's your
call.
Rick
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Blodgett, Jamie
Sent: Tuesday, July 18, 2006 8:58 AM
To: [email protected]
Subject: Re: Suggestions - DOB
So
sorry . . . I didn't mention the version . . .
ARS
5.0 (yes, we are unsupported and in process of upgrading now . . . on a test
box)
Oracle
8.1
HPUX
11
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___-----Original Message-----** You did not mention your ARS version but a Date field can hold a date that goes back to BC dates. A date\time field is limited to 12/31/1969
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank Caruso
Sent: Tuesday, July 18, 2006 11:17 AM
To: [email protected]
Subject: Re: Suggestions - DOB
On 7/18/06, Blodgett, Jamie <[EMAIL PROTECTED]> wrote:How are other's handling dates needed in ARS prior to 1/1/70? (such as Date of Birth) I've dug around the archives and KBs, but haven't found anything.
We have several instances where dates prior to 1/1/70 are needed in addition to DOB. So, it would be nice to know how others have tackled this.
Thanks!
Jamie Blodgett
Rinker Materials Corp.
Remedy Application Support
CONFIDENTIALITY: The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
