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

Filemaker handles date arithmetic automatically. In other words, if you take the contents of a date field, add one to it, and put the result into a date field, you will get the result you want.

Yes. And to figure your weeks, you can do some modulo-7 arithmetic or something of the sort, if you need to. Because of leap years, you may find it more convenient to have a table of dates (it's actually very easy to script) of the next ten or twenty or whatever years, in order to keep your weeks lined up right.

-Stanley