Adhoc Report showing 1 day (plus/minus) date difference than actual data in the Bizx instance.
Reproducing the Issue
Note the date in the system. Example: Start date of work experience in Employee Profile.
Adhoc Report is showing the date 1 day before the actual date.
We have a setting in Adhoc Report to convert the date/timestamp to the timezone of the logged in user (localized )running the report rather than the server time.
If the setting is enabled then the difference in the date in expected.
- Edit the Adhoc Report and go to Configuration tab.
- Click DataType Configuration and see if "Localized" setting is checked/unchecked.
3. Uncheck the option and run the report again. You will see the same date as in instance.
Adhoc Report 1 day date difference Localized , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem