Forum Discussion
You would need to mark an exception for Arizona to move it between PST/MST depending on the current date/daylight savings Period.
You could do something like:
var text adjustedTimeZone = if(
[State]="Arizona", if( //logic for first Sunday of Month, "Mountain","Pacific"),
[TimeZone]);
var duration TimeZoneAdjustment = Case ($adjustedTimeZone,
"Pacific", Hours(0),
"Mountain, Hours (1),
"Central", Hours(2),
"Eastern", Hours(3))
------------------------------
Chayce Duncan
------------------------------
Thank you, Chayce. I will play around with that. Appreciate the fast response. Have a good weekend.
------------------------------
Lorre
------------------------------
- ChayceDuncan7 months agoQrew Captain
Since you can bank on Standard time shifting on the first Sunday of November and the second Sunday in March - you can write the formula to check what day of the week the dates in November and March are to do the walk to what date Sunday actually falls on.
You could try and fanangle some logic using the FirstDayOfWeek formula - and check FirstDayOfWeek("11-8-" & Year(Today())).
if that value returns 11-8 exactly, that means that 11-8 is a Sunday and then the first Sunday of the Month was 11/1 since QB treats Sunday as the first day of the week. That formula returns 11-5 for the current year we're in so you would just leave it as is and use it along with a similar value to find March. With those two dates in hand you just check to see if Today() falls between them and then adjust the timezone accordingly.
------------------------------
Chayce Duncan
------------------------------