Date format problem in the prompt in XI3.1

system · November 11, 2009, 12:30pm

Hi,
I have a problem with date prompt. while I am running my report in infoview, it is showing perfect dd/mm/yyyy format, but when i am modifying the report and refresh… in the prompt it is showing mm/dd/yyyy format. Well, when i looked into the query… it is fine… it took dd/mm/yyyy fromat. But at the time of modifying only the view is mm/dd/yyyy format. suggestion will be appreciated. I think it is a bug kind of thing in BOXI3.1

Regards,
Manoj

manoj_k3 (BOB member since 2007-03-30)

system · November 12, 2009, 3:19am

Good Day,

Have you tried changing the format of your date in report?

jvmauricio (BOB member since 2009-08-03)

system · November 12, 2009, 8:55am

What’s the database? We’re on XIr2 and with SQL Server we had to change a parameter file on the server to show UK dd/mm rather than US mm/dd.

…Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\odbc\sqlsrv.prm

Changed

<Parameter Name="USER_INPUT_DATE_FORMAT">'mm/dd/yyyy HH:m:s'</Parameter>

to

<Parameter Name="USER_INPUT_DATE_FORMAT">'dd/mm/yyyy HH:m:s'</Parameter>

Debbie

Debbie (BOB member since 2005-03-01)

system · November 13, 2009, 10:28am

Hi,
database is oracle debbie.
REgards,
Manoj

manoj_k3 (BOB member since 2007-03-30)

system · November 13, 2009, 10:40am

You have a similar file for Oracle…

Mak 1 (BOB member since 2005-01-06)

system · November 13, 2009, 12:23pm

hi,
I do not find any such kind of parameter

regards,
Manoj

manoj_k3 (BOB member since 2007-03-30)

system · November 13, 2009, 2:00pm

try changing the “Preferred Viewing Locale:” option to “English (United Kingdom)” in your preferences.

Sushir Patel (BOB member since 2006-04-19)

system · November 13, 2009, 2:49pm

I don’t know what commectivity you re using Oracle native / ODBC, but you can add this parameter.

I think you have to re start the CMS after you have done it.

Have a look at the check list quoted in this post, it may help you:-

https://bobj-board.org/t/84923/22

Mak 1 (BOB member since 2005-01-06)

system · November 16, 2009, 10:13am

hi,
I have tried… but nothing helpful. I think it seems to be a bug in BO. Anybody is any other idea on this issue.

Regards,
Manoj

manoj_k3 (BOB member since 2007-03-30)

system · December 3, 2009, 2:30pm

I had a similar problem with DESKI however later discovered that the SDS download for the Deski users was configuring the local registry entries for XI to set the Country to ‘US’. Change the setting to ‘GB’ and you should have no issues. Users will require local admin rights on their PC to run REGEDIT to effect this.

Let me know how you get on.

katwild (BOB member since 2009-12-03)

system · August 26, 2010, 1:18pm

Hi,
We recently migrated from XIr2 to XIr3.1 and are currently experiencing an issue with date formats. Reports that worked in version 2 are not working in version 3. All new reports show same symptoms

we have amended the SQLSRV.PRM file and checked many other client settings that may be the cause.

the issue is although the web client indicates dd-mm-yyyy, when the report with date prompts is run an error occurs -
the conversion of a char data type to a datatime

this occurs when we enter ‘31/05/2010’, simply changing this to ‘05/31/2010’ produces an error from the web client.

Thanks in advance.

fmohammad (BOB member since 2010-08-26)