Forum Discussion
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
------------------------------
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
------------------------------