Okay, this - sort of - worked.
This is what I used :
Code:
=DateAdd("h",[Timezone],Now())
Works great - HOWEVER, it's calculating the wrong column.
My timezone field uses a lookup from the timezone table. That table is
ID
Name (Common name (IE: Central Standard Time) )
Offset (GMT Offset (IE: -6) )
Code (Name abbv (IE: CST) )
In the lookup I show two columns ( Name & Offset ) but I only save the ID
Using the above mentioned method, it appears to be calculating on the record ID when I need it to calculate on the offset.
Is there a way to target it to that column OR should I modify the timezone table by getting rid of the ID column and using the Offset column as a primary key and reference?