Time Zone change
Good morning, I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. C...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe way to approach this is to have a table where the Key field is the city / airport code. On that table you would have an offset to central time. The make a relationship back to the Pickups table. That offset with be looked up into the Pickups table and used to calculate the local time.
Expanding on Mark's answer, you should have two offsets. One for Standard Time and one for DST. There are places that do not change the clocks, particularly Arizona does not observe DST. Same with parts of Indiana and so on.
Then you make an If Statement in the Pick Ups table to use either offset on whether or not Today() is Standard or DST.