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 are you reading the date values? I > have > previously posted date field conversion functions for MS-SQL, > Oracle, and > Informix. You can find these in the ARSList archives under a > thread titled > "Integer date conversion in Business Object WebIntelligence", 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 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 field data > to a date? > > > > Any assistance is greatly appreciated. > > > > Many Thanks. > > > > Audrey Franklin > > Senior Systems Analyst > > New York University > > [EMAIL PROTECTED] > > > > _______________________________________________________________________ ________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org