Re: Question regarding Date field NOT the Date-Time field

2007-04-19 Thread Vyom Labs - ITSM Support
] 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

Re: Question regarding Date field NOT the Date-Time field

2007-04-19 Thread Thomas Bean
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

Re: Question regarding Date field NOT the Date-Time field

2007-04-19 Thread Shyam Attavar
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

Re: Question regarding Date field NOT the Date-Time field

2007-04-19 Thread Grooms, Frederick W
: 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

RESOLVED: Question regarding Date field NOT the Date-Time field

2007-04-19 Thread Shyam Attavar
: 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

Re: Question regarding Date field NOT the Date-Time field

2007-04-19 Thread Joe D'Souza
, 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

Question regarding Date field NOT the Date-Time field

2007-04-18 Thread Shyam Attavar
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

Re: Question regarding Date field NOT the Date-Time field

2007-04-18 Thread Joe D'Souza
@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

Re: Question regarding Date field NOT the Date-Time field

2007-04-18 Thread Frank Caruso
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

Re: Question regarding Date field NOT the Date-Time field

2007-04-18 Thread Joe D'Souza
] 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