Unusual Date Calculation need help

[hartmut77]

Hello

I have a situation where my client has a meeting every Tuesday. In my database I would like to have the field calculate the date of the last meeting until the actual date of the next meeting. Is this possible.

In other words if the last meeting was Tuesday 1/27/2004 - everytime I perform the script with the calculation it remains 1/27/2004 UNTIL 2/03/2004

Then it would remain 2/03/2004 until 2/20/2004

So the formula would be based on today.

Can Someone help me with a calculation for this baby.

Thanks

Dave

[-Queue-]

Try Status(CurrentDate) - Case(DayofWeek(Status(CurrentDate)) >= 3, DayofWeek(Status(CurrentDate)) - 3, 4 + DayofWeek(Status(CurrentDate))).

[hartmut77]

Thanks man

It worked like a charm.

Great help from you

Have a great day

Dave