Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago

Calculate next 2nd Tuesday of a month

I have a task due to submit every 2nd Tuesday of month , for life of me I can't figure how to calculate next instance . ------------------------------ Prashant Maheshwari ------------------------...
Formulas and functions
TateForgey's avatar
TateForgey
Qrew Assistant Captain
This is just what I need, Mark.  Thanks! However, as I create the formula date field and look at it today (November 10, 2021) it produces an incorrect value. The date it produces is November 16, 2021.  The second Tuesday of this month was November 9, 2021. The code should have given me the second Tuesday of next month (which it is calculating correctly). 

I'm trying to unpack your code, but if you get to it first, do you know why this is and how we can fix it?

------------------------------
Tate Forgey
------------------------------
TateForgey's avatar
TateForgey
Qrew Assistant Captain
3 years ago
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
------------------------------