Forum Discussion

TateForgey's avatar
TateForgey
Qrew Assistant Captain
4 years ago

Re: Calculate next 2nd Tuesday of a month

While I'm conceptualizing how to fix delta, I'm inserting a blunt force attack:

Case(DayOfWeek( (FirstDayOfMonth(Today()))),
0, FirstDayOfMonth(Today()) + Days(9),
1, FirstDayOfMonth(Today()) + Days(8),
2, FirstDayOfMonth(Today()) + Days(7),
3, FirstDayOfMonth(Today()) + Days(13),
4, FirstDayOfMonth(Today()) + Days(12),
5, FirstDayOfMonth(Today()) + Days(11),
6, FirstDayOfMonth(Today()) + Days(10)
)

------------------------------
Tate Forgey
------------------------------
No RepliesBe the first to reply