How to calculate the 3rd wed of every third month?

[dscott321]

I have a business meeting that occurs the third Wed. of every third month. (i.e. this year Jan. 16, April 16, July 16, and Oct. 15) I would like to find a way to automatically calculate the next three meeting dates in (01-01-08) format.

Thanks in advance for your help

Dave

[mr_vodka]

If this is strictly for display purposes, you can use a repeating calculation.

Create a field that is for the year and then have a repeating calc with 4 repetition and date result.

Let ( [ d = Date ( Get ( CalculationRepetitionNumber ) * 3 - 2; 1; Extend (YourYear) );

          w = DayOfWeek ( d )

        ];

        d - w + 18

      )

P.S. This is pending that for dates such as Jan 2009, you want 01/14/2009 as a result.

Edited July 12, 2008 by Guest

[comment]

That doesn't look right, John.

[mr_vodka]

I havent fully tested it yet but am I missing something?

It should always be months 1, 4, 7, 10 I assumed.

So if you take the start of the week that day 1 for each of those months resides in and then add 17 days which should always be the 3rd wed correct?

[comment]

No, because if the month starts on Thursday or later, the first Wednesday of your count is still in the previous month.

[mr_vodka]

P.S. This is pending that for dates such as Jan 2009, you want 01/14/2009 as a result.

Right that is why I put this in earlier because I didnt want to assume that is what the OP wanted. Becuase Jan 2009 is exactly the issue that you state.

I guess it can easily be modified if the TRUE 3rd wed for each individual month is what is wanted.

Let ( [ d = Date ( Get ( CalculationRepetitionNumber ) * 3 - 2; 1; Extend (YourYear) );

          w = DayOfWeek ( d )

        ];

        d - w + 18 + Case ( w > 4; 7 )

      )

Edited July 12, 2008 by Guest