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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate minutes in different time zones 2
short time calculations 4
Drop down list & Time Zones. 2
If statements with times - possible issue with the formatting of t 6
Calculating the Time In A Time Zone 1
Outlook does not display time zones correctly. 3
Calculating time? 2
current time zone date query 1

Back
Top