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 ------------------------...
Forum Discussion
How about this.. where test date is the date you are using to identify the month
var number firstday = DayOfWeek(FirstDayOfMonth([test date]));
var number delta = 9 - $firstday;
If ($delta < 2, FirstDayOfMonth([test date]) + Days($delta),FirstDayOfMonth([test date]) + Days($delta + 7) )
------------------------------
Pete James
------------------------------
var number firstday = DayOfWeek(FirstDayOfMonth([test date]));
var number delta = 9 - $firstday;
If ($delta < 2, FirstDayOfMonth([test date]) + Days($delta),FirstDayOfMonth([test date]) + Days($delta + 7) )
------------------------------
Pete James
------------------------------