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
7792 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

Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.

6 Answers TCS,

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers Cap Gemini, Deloitte,

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers IBM,

How many built-in objects are created in Business Objects repository?

2 Answers

Why do we need metrics and sets?

1 Answers

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers iGate,

What is the use of BO SDK?