Prompt in dd/mm/yyyy format

[Former Member]

Hi,

I need to accept data from user in dd/mm/yyyy format, but as of now the default format what the prompt is taking is mm/dd/yyyy.

Considering the prompt as 'Date from'. Kindly help me out with the code for dd/mm/yyyy.

As of now the query is MRK.Data.From_Date=@Prompt('Date from','D',,,).

Thanks.

Jim

[Former Member · Accepted solution]

Hi,

The date format of the prompt is controlled by a prm file on your Busienss Objects server

Open your universe, parameters and test connection

Open details - locate PRM file being used

Go to Business Objects Server

Open PRM file using notepad

Locate line below and edit date to required format

<Parameter Name="USER_INPUT_DATE_FORMAT">{\d 'yyyy-mm-dd HH:mm:ss'}</Parameter>

Re-start connection server

Test your date prompt....

These links may be help you:

http://forumtopics.com/busobj/viewtopic.php?p=628947&sid=a6dffd86c651cd070aac2649459b25a4

Edited by: Swarna K on Mar 22, 2011 7:46 AM

[Former Member · Accepted solution]

Thanks for the reply. Is it possible to try something @ the universe level or @ the report level(Custome sql). Any suggestions to use any functions. I tried to_Date() but not able to solve it .

Please let me know if anything is possible.

Thanks.

Jim

[Former Member · Accepted solution]

Click on the objects property.

Now go to the second tab in the LOV click on edit

You can find Query Panel. Jus click on click on SQL.

change the Date formate in SQL and save it.

Hope this will help you out.

[Former Member · Accepted solution]

Thanks Swarna. I solved the problem using custom sql and to_date() report level.

[Former Member · Accepted solution]

Hi Jim!

You can define objects in your universe where you define the input: ie

Object: Prompt From

SQL: to_date(@Prompt('1 Period from (dd/mm/yyyy)','A',,MONO,FREE),'dd/mm/yyyy')

This works for Oracle, requiring the user to input the date as text, which will be interpreted by the DB. But you will loose the calendar prompts from BO.

ciao Hakan