Jarvis Posted February 15, 2005 Share Posted February 15, 2005 I'm trying to build a payroll module that tracks total hours based on calendar days and work weeks. I would like to have record 1 date field to be January 1 and have each successive record add one day to the calendar. Day 1 = January 1 Day 2 = January 2 Day 32 = February 1 Day 365 = January 31 Etc. I am hoping to total payroll hours per day and per week, with the year broken into 52 weeks. Is there a function that can add one day to the preceeding day and keep the month and date accurate? I don't if I explained this right but I still hope someone understands what I am talking about and can aim me in the right direction. Thanks, Jarvis Link to comment Share on other sites More sharing options...
This topic is 6613 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 account
Already have an account? Sign in here.Sign In Now