How to Disable Column Time Zone Offset in Reports

You can view a report in the same date from different time zones by disabling the column time zone offset for such date/time columns.

Some of the dates in the report showing a one day off for some users and not for others viewing the same report. This is because the date/time in the report is converted to the user's time zone.

Example: When user A runs the report Reported Time Card Start Date and Time shows 12-12-2015. However, when user B runs the same report for the same record, it shows one day earlier 12-11-2015.

Here's how you can disable the Column Time Zone Offset for such columns.

Note: The column has to be date/time and not just date.

1. Log in as an user with Admin access

2. Create a new analysis against the subject area, which has the Time stamp columns not applicable for time zone offset.

3. Select the time stamp columns which you want to disable the time zone offset.

4. For each selected column, select Column Properties from the drop-down menu.

5. Navigate to the Data Format tab,

6. Check the Override Default Data Format checkbox to modify its format and change the Date Format to any 1 of the first 3 custom display formats.

7. Change Data Time Zone Offset to Data time zone.

8. If you only want to change it for this specific report, click OK.

   However, if you want all the reports using this column to have the same effect, click Save as Default and pick the second option Save as the system-wide default for "…t Date and Time" .

9. Repeat steps 4 to 8 for each selected Time stamp column you want to disable the time zone offset.

Note: If you want to truncate the time from the displayed date, you can use the CAST function. Here are the steps:

1. Click on the column in question and select Edit Formula.

2. CAST(Column_Name as Date).