Use CASE or IF statement?

[Lee Smith]

Please make up your mind of what you want.

First you ask for a count down and now you want a count from.

Two entirely different calculations.

Lee

[KLA]

sorry, i'm not an expert at this. I need to caluclate TODAYS DATE - THE ANNIVERSARY OF THE PERSONS START DATE and have it return in weeks.

Example:

If they started on 5/8/01, then it would be 6/8/03(today) - 5/8/03 {= 6 weeks}

If they started on 12/8/98, then it would be 6/8/3 - 12/8/02 (since this is the most RECENT anniversary date) {= 26 weeks}

The purpose is to tell me how many weeks they have worked in their CURRENT year of employment so i can tabulate how many vacation days they have earned so far in their current year. Everyone's vacation days start over on their start date anniversary. Hope this is more clear.

[Lee Smith]

KLA

Here is the reverse of the last one and should be what you want.

Mod(WeekofYear(Status(CurrentDate)) - WeekofYear(Date of Hire) +

WeekofYear(Date(12,31,Year(Status(CurrentDate)))), WeekofYear(Date(12,31,Year(Status(CurrentDate)))))

Lee

[KLA]

I THINK this works. I have to make sure it's what my boss wants but looks good! THANKS sooooo much for both of your help!!