Re: Suggestions - DOB
**
Jamie,
Another approach is to use a character field to hold
the formatted DOB that you display, and an integer field to hold the number of
seconds from today. The integer field could be used for sorting, searching
(ie. people with a birthday next month) or performing math (ie. schedule 90-day
review from hire date).
To set the integer field with Set Fields SQL (for SQL
2000): SELECT DATEDIFF(s, '$DOB Char$',
GETDATE())
Whereas, $DOB Char$ would contain something like
"07/18/1980".
For validating dates typed in by users run the Set
Fields SQL: SELECT ISDATE('$DOB Char$')
If the date is valid then 1 is returned, else
0.
HTH
Stephen
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe
DeSouzaSent: Tuesday, July 18, 2006 1:05 PMTo:
arslist@ARSLIST.ORGSubject: Re: Suggestions -
DOB
**
Then there is not much you can do on your current version of the ARS as
that version backwards wasnt compatible to hold dates below the epoch date
range.. The closest you could get is developing a calender functionality using 3
display only fields one for the date the other for the month and the last for
the year - I think that might be possible by building some logic to consider the
date ranges for specific months and leap year considerations...
Using the inputs from these three strings you could build a date
string..
Off course this date string would be only useful as a string and you would
be very limited to manupulations possible on this string...
Regards
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Time Warner Cable Project,
Virginia.
-
Original Message From: "Blodgett, Jamie"
<[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Tuesday, July
18, 2006 11:57:38 AMSubject: 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
-Original Message-From: Action Request System
discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank
CarusoSent: Tuesday, July 18, 2006 11:17 AMTo:
arslist@ARSLIST.ORGSubject: Re: Suggestions -
DOB** 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
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 BlodgettRinker
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 CarusoSpecific Integration, Inc.Senior
Remedy Engineerwww.specificintegration.com703-376-1249
__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with
HTML in it_20060125___This posting
was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** Then there is not much you can do on your current version of the ARS as that version backwards wasnt compatible to hold dates below the epoch date range.. The closest you could get is developing a calender functionality using 3 display only fields one for the date the other for the month and the last for the year - I think that might be possible by building some logic to consider the date ranges for specific months and leap year considerations... Using the inputs from these three strings you could build a date string.. Off course this date string would be only useful as a string and you would be very limited to manupulations possible on this string... Regards Joe D'Souza Remedy Developer / Consultant, BearingPoint, Time Warner Cable Project, Virginia. - Original Message From: "Blodgett, Jamie" <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Tuesday, July 18, 2006 11:57:38 AMSubject: 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 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** 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 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 BlodgettRinker 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 CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** 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, JamieSent: Tuesday, July 18, 2006 8:58 AMTo: arslist@ARSLIST.ORGSubject: 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 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** 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 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 BlodgettRinker 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 CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
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 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** 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 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 BlodgettRinker 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 CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
Well, for starters, you could use Date fields instead of Date/Time fields. Those go back before any of us (except for Dick Clark) were born. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Blodgett, Jamie Sent: Tuesday, July 18, 2006 7:51 AM To: arslist@ARSLIST.ORG Subject: Suggestions - DOB 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 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Suggestions - DOB
** 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/1969On 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 BlodgettRinker 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 CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** Jamie, I would think the Remedy Date field (not Date/Time field) would able to handle this requirement... I'm sure you do not quite require the Date/Time Field for DOB's anyway as its not too critical for most applications to know the exact time of birth... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Time Warner Cable Project, Virginia. - Original Message From: "Blodgett, Jamie" <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Tuesday, July 18, 2006 10:50:47 AMSubject: Suggestions - DOB 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 BlodgettRinker Materials Corp.Remedy Application SupportCONFIDENTIALITY: 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 __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
Title: RE: Suggestions - DOB ** Jamie Use a Date field. You can go back to 4173 BC! James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Blodgett, Jamie Sent: Tuesday, July 18, 2006 7:51 AM To: arslist@ARSLIST.ORG Subject: Suggestions - DOB 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 __20060125___This posting was submitted with HTML in it___
Suggestions - DOB
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
