Convert Remedy Date/Only Field

2006-10-19 Thread Audrey Franklin
Good Afternoon, I am trying to convert Remedy Date/Only field to a date for reporting purposes, and discovered that the Date/Only field stores date information as the number of days from the beginning of its range relative to 1/1/4713 B.C. Is there a script that I can use to convert the Date

Re: Convert Remedy Date/Only Field

2006-10-19 Thread Thomas Bean
uot;, from late last month. --Thomas - Original Message - From: "Audrey Franklin" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general Sent: Thursday, October 19, 2006 13:21 Subject: Convert Remedy Date/Only Field Good Afternoon, I am trying to convert R

Re: Convert Remedy Date/Only Field

2006-10-19 Thread Audrey H Franklin
Thomas, I am working with Oracle 9i database. Will look for your post on the ARSLIST. Thanks, --Audrey - Original Message - From: Thomas Bean <[EMAIL PROTECTED]> Date: Thursday, October 19, 2006 3:16 pm Subject: Re: Convert Remedy Date/Only Field > Audrey, > From

Re: Convert Remedy Date/Only Field

2006-10-19 Thread Thomas Bean
YY') FROM DUAL; --Thomas - Original Message - From: "Audrey H Franklin" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general Sent: Thursday, October 19, 2006 14:24 Subject: Re: Convert Remedy Date/Only Field Thomas, I am working with Oracle 9i dat

Re: Convert Remedy Date/Only Field

2006-10-19 Thread Audrey H Franklin
Thomas, This worked. Thanks a Bunch! I appreciate your assistance. Audrey - Original Message - From: Thomas Bean <[EMAIL PROTECTED]> Date: Thursday, October 19, 2006 4:43 pm Subject: Re: Convert Remedy Date/Only Field > Audrey, > Oracle has built-in functions that can hand