Inconsistent date formats between Rich Client and HTML client

[Former Member]

Hey All,

Just wondering if anyone has come across an issue with inconsistent date formats from a universe based on an MS SSAS 2012 database connection in 4.x?

The value of the date is returned as a string from the query but the object data type has been changed to a Date object meaning BusinessObjects should convert the string into a date if the format is correct.

The problem in this is that the date being returned in Rich Client is in dd/MM/yyyy format whereas on the Web Client is in MM/dd/yyyy.

From the Web Client business objects will return a date, however, it is a mix of MDY and DMY format.

i.e. 15th of March will be displayed as 15/03/2014

whereas 12th of March will be displayed as 03/12/2014

All our application servers are configured for English (Australian) regional settings meaning all dates should be in DMY format.

The date in the database is stored as a non-ambiguous yyyy-mm-dd format so it appears the variation is occurring somewhere between the database and BusinessObjects for the Web Client based reports only.

I have also checked the sqlsrv.prm file based format and changed this to DMY but this has also not made a difference.

The same universe in 3.1 and MS SSAS 2008 works correctly but not this one.

[former_member4998]

Hi

The date in the database is stored as yyyy-mm-dd format.

As per user request.... Set the date format @ the Business layer level. so it will refelct same as in the WebI.

Please find the below link. how to use custom Display option.