Date Times Issue

building reports webintelligence
1

Hi

We are using BO 4.2 SP6. We have a free hand sql report, the query is very simple -> Select * from Table A
Now when we are running the SQL in database, we are getting the date value 1 day more than what we getting in report. For e.g. we are getting date in DB as 31st Dec 2020 whereas in report we are getting 30th Dec 2020. The DB values seems to be correct. In the report no formula is used, the date column is direct mapping. Any idea why we are getting different date values?

Thanks

2

These fhsql reports were converted from DeskI to WebI.

3

Have you looked at the Locals and Time Zone settings for the users running the report? It could be altering the dates. This may be especially true if you are operating over different time zones.