Thomas/Fred,
Thanks for the conversion (I was able to pull the reports in a jiffy with the
script) and for pointing me to the details in the documentation.
You guys are the best!!
Cheers,
--
Shyam
----- Original Message ----
From: Thomas Bean <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, April 19, 2007 7:45:24 AM
Subject: Re: Question regarding "Date" field NOT the "Date-Time" field
Shyam,
If you are using an Oracle DB, there is a very simple native function you
can use to convert the date fields:
select to_char(to_date(2449992, 'J'), 'MON-DD-YYYY') from dual;
In the above example, simply replace the value '2449992' with the column
name of the date field from the Remedy view.
HTH,
Thomas
----- Original Message -----
From: "Shyam Attavar" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <arslist@ARSLIST.ORG>
Sent: Wednesday, April 18, 2007 18:10
Subject: Question regarding "Date" field NOT the "Date-Time" field
Dear listers,
I am trying to run reports through Business Objects universe that directly
points to the Remedy views in the Oracle DB. However, there is one field
that is created as a Date field and I would like to convert the data stored
in this field to something more meaningful in Business Objects. I was
wondering if there is some calculation any of you have readily available to
do this conversion.
Any pointers in this regard would be really helpful and much appreciated.
Thanks in advance.
Cheers,
--
Shyam
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
