Lee Smith Posted June 19, 2003 Share Posted June 19, 2003 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 Link to comment Share on other sites More sharing options...
KLA Posted June 19, 2003 Author Share Posted June 19, 2003 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. Link to comment Share on other sites More sharing options...
Lee Smith Posted June 19, 2003 Share Posted June 19, 2003 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 Link to comment Share on other sites More sharing options...
KLA Posted June 26, 2003 Author Share Posted June 26, 2003 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!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7607 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now