World Time Calculation

[Ali Edwards]

Hi all!

Surely this has to be simple but I'll be jiggered if I can make it work.....

I have a field which is called 'Local Time' and in it is a value depending on the time difference between that country and mine, say "+7" for Brunei and "-12" for Hawaii. How do I get the local time to show in each record.

I have tried =Time()+ Me![Local Time] and variations on that but just can't get there and I am fairly new to this!

Thanks for any help you can offer.

 

[Ali Edwards]

Got it!

Made up a separate form that references the time difference in my main form.

Private Sub Form_Open(Cancel As Integer)
'Time = DateAdd("h", [Forms]![Master Input Edit]![Time Difference], [UK Time])
Forms![Time]![UK Time] = Now()
Time = DateAdd("h", ([Forms]![Master Input Edit]![BST]), [UK Time])
Forms![Time]![Time GMT] = DateAdd("h", ([Forms]![Master Input Edit]![GMT]), [UK Time])
End Sub

Private Sub Form_Timer()
Forms![Time]![UK Time] = Now()
Time = DateAdd("h", ([Forms]![Master Input Edit]![BST]), [UK Time])
End Sub