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 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 what type of database

Re: Convert Remedy Date/Only Field

2006-10-19 Thread Thomas Bean
- 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 database. Will look for your post on the ARSLIST. Thanks

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 handle this type