in a database date formate is in dd/mm/yy. In my report I want when I prompt t

in a database date formate is in dd/mm/yy. In my report I
want when I prompt the date coloumn it should be
displayed in (yyyy/mmm/dd)format.
how could I do this

plse send me as soon as possible.

Question Posted / aditya

3 Answers
7764 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it ..

Answer / guest

Change the object SQL, I mean in SELECT class of that
object conver that by using the to_date or correct syntax.

Is This Answer Correct ?

6 Yes

3 No

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it ..

Answer / aditya

create a derive table for that
select to_char(hire_date,'yyyy/mmm/dd') as date from
employees

it will work when you use in the prompt

Is This Answer Correct ?

4 Yes

1 No

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it ..

Answer / yogendra

Go ahead and make the change in the .prm file. So you will
be doing the change only once. And it will be universal for
all the objects.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More Business Objects Interview Questions

Can any body tell me,What is the universe testing ? What is the report testing Explain?

2 Answers

How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?

1 Answers WinAlliance,

Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?

1 Answers

Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.

2 Answers TCS, Wipro,

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers Accenture,

can i use stored procedure in webi?

4 Answers CTS, Wipro,

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers

How to create predefined filters in B.O.

2 Answers TCS,

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers Infotech,

what is xcelsius architecture?

0 Answers Zensar,

Shall we connect to the oltp systems directly .,

2 Answers iNautix,

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers

For more Business Objects Interview Questions Click Here