] Behalf Of *Frank Caruso
*Sent:* Wednesday, April 18, 2007 7:44 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Question regarding Date field NOT the Date-Time
field
** Will the ARS ODBC driver allow the joining of tables(views)? I
know it does not in excel, access and crystal
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
Subject: Re: Question regarding Date field NOT the Date-Time field
**
To the best of my knowledge, no, but a workaround could be to create that
join internally within the ARS and then report from BO out of that join..
Another alternative could be to create the join from the DB, create
: gmane.comp.crm.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, April 18, 2007 8:45 PM
Subject: Re: Question regarding Date field NOT the Date-Time
field
**
To the best of my knowledge, no, but a workaround could be to
create that join internally within the ARS
: 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-') from dual
, April 19, 2007 11:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Question regarding Date field NOT the Date-Time field
**
Joe/Frank,
The BO universe has been setup a while back pointing directly to the DB
views does not go through the ODBC Driver. I do not have the privilege to
change this at the moment
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
@ARSLIST.ORG
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
the data tables?
Joe
-Original Message-
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] Behalf Of *Shyam Attavar
*Sent:* Wednesday, April 18, 2007 7:10 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Question regarding Date field NOT the Date-Time field
** Dear
] Behalf Of Frank Caruso
Sent: Wednesday, April 18, 2007 7:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question regarding Date field NOT the Date-Time field
** Will the ARS ODBC driver allow the joining of tables(views)? I know it
does not in excel, access and crystal. Does it work different
10 matches
Mail list logo