Skip to main content
Question

Current Date and Time based on Time Zone

  • July 31, 2017
  • 0 replies
  • 304 views

How can I create Date / Time field that would show current Date / Time based on my Time Zone? I already used Now() but still the current field I have is showing U.S. Eastern Time. How can I make it based on my own Time zone. Please advise.
This topic has been closed for replies.

I assume that you know that you can set the app to a particular Time Zone for all users, but you are saying that you are in a different time zone from most of the rest of the users.

You would need to have a table of users with a key field of userid and their time zone offset from the time zone that the app is set for.  Then a relationship to any other tables in the app where you want to show local time and have a calculated field which calculates the Now() value or any other date/.time field such as [Date created] and add hours according to the offset.  

The right side of the relationship will need to be a formula user field typically called [Current User] with a formula of User()

 for example

[Date Created] + Hours([offset hours])

  • Author
  • Quickbase Alumni
  • August 1, 2017
Where can I create a table of users? And how should I do it?

You would create a New Table called perhaps User Time Zones with a Key field of userid and a field for the hours offset as a numeric field.

  • Quickbase Alumni
  • April 23, 2018
Is there a way to get the current date/time (on a button and then to a field) when the user hasn't refreshed the page in a couple of hours? (Attempting to track time dedicated to work, so they open a record when they start to work on a given task, but they consistently fail to refresh before closing it (using a button) so it stores the date/time of the last page refresh, instead of the current time.