Change Date Formats in Business Objects to UK Style

[Former Member]

We have an issue where we cannot get Business Objects to use UK style Dates (DD/MM/YYYY) in WEBI or DESKI when a date is chosen from a prompt.

We get the following error:

Database error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)

On inspecting the generated SQL:

SELECT

dbo.dim_report_context.REPORTING_DATE

FROM

dbo.dim_report_context

WHERE

dbo.dim_report_context.REPORTING_DATE In ( '08/21/2008 00:0:0' )

The date being sent to MS SQL is in US style. Our MS SQL database requires dates in the format DD/MM/YYYY. We are not in a position to change the database date format, so we need BO to change.

Any ideas?

Edited by: Jhai Watson on Aug 21, 2008 5:45 PM

[Former Member]

Found an answer...

In designer, on the advanced tab of the object, set the database format.

Its a shame that this cannot be applied globally.