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

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, 200817 yr by Guest

That doesn't look right, John.

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?

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

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, 200817 yr by Guest