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
