Forum Discussion
Are all of your used in the Pacific Time Zome?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- KimG2 years agoQrew Cadet
Yes, all of our users are in the Pacific time zone.
------------------------------
Kim G
------------------------------- MarkShnier__You2 years agoQrew Legend
Sorry for bing slow to respond. I'm half on vacation this week.
Not tested for Syntax but try this approach
var duration TimeZoneAdjustment = Case ([TimeZone],
"Pacific", Hours(0),
"Mountain, Hours (1),
"Central", Hours(2),
"Eastern", Hours(3))
var TimeOfDay AdjustedTime = ToTimeOfDay(Now() + $TimeZoneAdjustment);
IF($AdjustedTime >= [Time Open] and $AdjustedTime <= [Time Closed), "Open", "Closed")
var text
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- KimG2 years agoQrew Cadet
Thanks Mark! That works great!
Since I realized we don't always have the opening hours listed I added a second statement to capture the actual close time.
Then I adjusted so it actually shows the local time too so on those accounts without an open/close time listed (particularly overseas vendors) we can have an idea if it might be the right time of day to call.
Instead of "Open" it's now "Open. The local time is " &$AdjustedTime
Thanks for taking time out of your vacation to help me out. My fellow QB users and I really appreciate it.
Kim
------------------------------
Kim G
------------------------------