Calculating Current Time in other Time Zones

  • Thread starter Thread starter AJ
  • Start date Start date
A

AJ

My Google searches have come up dry...

I am am toying with a text box with the control source of...

=DateDiff( "h", Me!cboUCT , Now() )

Where Me!cboUCT is a lookup combo box that returns the Unified Coordinated
Time (Mountain Time returns 7:00).

I am trying to have a text box that will show me the current time within
another Time zone, for each record I look at...

My way isn't working. How should I go about this?
 
I think DateAdd is the function you want, not DateDiff. DateDiff calcs the
difference between two date/time values. DateAdd computes a new time.

TomU
 
Back
Top