Good Day,

We had built a new obiee server and moved our code and implemented same config changes in the new server.

But we identified that the date column format is not matching between new and old servers.

We had verified below things to make sure nothing is missing.

1. There is no custom formatting on the column level.
2. Database and obiee servers are on the same location with same time zone.
3. Date format mentioned in the nqs config file of both the servers is same.

From NQS config:

DATE_TIME_DISPLAY_FORMAT = "yyyy/mm/dd hh:mi:ss";  

DATE_DISPLAY_FORMAT = "yyyy/mm/dd";  

TIME_DISPLAY_FORMAT = "hh:mi:ss"; 

Old server report format : 2015/03/31 06:42:54 PM 

New Server report format : 3/31/2015 6:42:54 PM 

Please suggest if we are still missing something

Thanks