Calculating Current Time in other Time Zones

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?
 
T

TomU

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
 
Top