Current Date and Time based on Time Zone
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 ba...
Forum Discussion
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])
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])