AnsweredAssumed Answered

Custom Pay Period Cycle

Question asked by captainamerica24 on Oct 20, 2016
Latest reply on Oct 20, 2016 by philmodjunk

I recently created a database made for keeping track of timecards of employees. The Pay Periods rotate each month, so Pay Period goes from Sunday to Saturday (October 16–October 29), (October 30–November 12), (November 13–November 26), (November 27–December 10), etc. The pattern stays the same, but is there a way to automatically generate the Start/End date of the Pay Period, and automatically tell which Day belongs in which Pay Period. So, for example, I write a script that will get a list of all days worked in any given pay period (worked Monday–Friday and Monday–Friday in the October 30–November 12 period), to determine the amount of hours (70), then send this as a PDF to the accountant. Is there a way that FileMaker can tell which dates belong to which pay periods, the pay periods being auto-generated by a calculation?