Time Corrections for Reports
Working with a report, we made some interesting discoveries about the time corrections/updates
We are using the following Parameters:
Starting Entered Date (Date) formatted as Data type: "Date/Time"
Ending Entered Date (Date1) formatted as Data type: "Date/Time"
TimeZone formatted as Data type: "Text"
Label: Eastern, Central, Mountain, Pacific
Value: +1, 0, -1, -2
It may also help to set a default value: e.g. -2 for Pacific
Note: It depends on where your data warehouse is located..
If we look at the "DataSet Properties…" of DataSet1
We need to go to Parameters:
Click the OK Button
We are going to be changing the following..
Results are: 8/21/2010 9:18:50 AM
If we look up this ticket we see that the time is not correct (off by two hours).
So.. We need to change to:
Result are: 8/21/2010 7:18:50 AM
Caution: If you make the change to:
The Entered Date is not correct!
Be able to display a desired TimeZone like Pacific Time and not the server time in GMT, e.g. -8
With Microsoft Access and Microsoft Excel, for example: We can use KERNEL32 to get the user's system time/date
Date for a Ticket - GMT (Raw Date on the server):
Entered Date for a Ticket (adjusted for TimeZone) - GMT:
Convert UTC to Local Time for an Entry:
Convert UTC to Local Time (Real Time) for a ticket: