Platform: Windows Server 2003
Business Objects XI Release 2 Desktop Intelligence.
A customer has reported that American dates are being forced in Business Objects. All the setting I can think of have been set to UK, but it refuses to allow entry of dates in UK format for a prompt on a report.
[list][:0dce18e724]If they enter ‘01/04/07’, some strange date is formed which results in data being returned from as far back as 1996.
[:0dce18e724]If they enter ‘01/04/2007’, then data is returned from January 4th 2006 - in the UK, a date of ‘01/04/2007’ means the 1st of April 2007. Looking at the SQL formed shows that BO has changed the date into US format.
[:0dce18e724]Entering a date such as ‘13/10/2007’ is interpreted as the 10th day of the 13th month, and this is an invalid date.
[:0dce18e724]Hardcoding the dates are acceptable in US format[/list]
I am unable to recreate the problem in-house, even using the customer’s report. The back-end database is Oracle 10g.
Actions tried (all to no avail) include:
[list][:0dce18e724]Checking the Registry NLS_LANG for the database for the character set. Our applications require a setting of AMERICAN_AMERICA.WE8ISO8859P1. I know that might sound wrong, but thst’s the setting in-house and it works perfectly.
[:0dce18e724]They do not have an NLS_TERRITORY set up - would that make a difference?
[:0dce18e724]In Dektop Intelligence, went to Tools >> Options. Ensure the Language dropdown was set to English. There is a button to the right, and we changed that setting both to “English (UK)” in the Unsupported Languages and “English” in the supported ones. No difference.
[:0dce18e724]Ensured that the Regional Settings are set to UK, together with UK formats for currency, date, and time
[*:0dce18e724]Ensured that the Timezone is set to GMT (shouldn’t make any difference really)[/list]
It seems that nothing we try will allow the customer to enter dates in UK format. Are there any other setting we can try? I’m fairly sure it’s a BO thing rather than an Oracle one.
Angoid 
(BOB member since 2004-11-30)
