end of week calc

[elvis_impersonating_penguin]

ok i need a calculation that, based on one date, will give me the date of the next saturday. basically i am just trying to find out the ending date of the week. so for today (3/25/2002) the new field would display 3/30/2002.

thanks

[elvis_impersonating_penguin]

well nevermind.. i was able to find the answer on the DatabasePros website.. thanks anyway

DateField + 7 - DayofWeek(DateField)