After Update: Pay Period Date

[Michael]

I have a table called "PayPeriod" where our pay period end dates are
stored.

I have a table called "Accounting" where employee work dates/times are
stored.

The pay period end date table lists the last date of each pay period.
Example pay periods are: 10/1/2011, 10/15/2011, 10/29/2011, etc. Any
work day which occured after 10/1 and up to 10/15 would be identified
as the 10/15 pay period. If the employee entered a work date of
10/16, it would be assigned to pay period 10/29. If the employee
entered a work date of 10/29, it would also be assigned to pay period
10/29. If the employee entered a work date of 10/14, it would be
assigned to pay period 10/15.

When we use our time entry form, I would like to have an after update
that would fire when they enter the work date to look at the pay
period end date and determine which pay period it belongs to and enter
that pay period end date into the field in the timesheet form field
"pay period end date".

Can someone help me determine the after update code that would be
needed to make this happen?

 

[Mike Painter]

I have a table called "PayPeriod" where our pay period end dates are
stored.

I have a table called "Accounting" where employee work dates/times are
stored.

The pay period end date table lists the last date of each pay period.
Example pay periods are: 10/1/2011, 10/15/2011, 10/29/2011, etc. Any
work day which occured after 10/1 and up to 10/15 would be identified
as the 10/15 pay period. If the employee entered a work date of
10/16, it would be assigned to pay period 10/29. If the employee
entered a work date of 10/29, it would also be assigned to pay period
10/29. If the employee entered a work date of 10/14, it would be
assigned to pay period 10/15.

When we use our time entry form, I would like to have an after update
that would fire when they enter the work date to look at the pay
period end date and determine which pay period it belongs to and enter
that pay period end date into the field in the timesheet form field
"pay period end date".

Can someone help me determine the after update code that would be
needed to make this happen?

Do you always pay on the 15th and 29th or would 10/29 be followed by
11/13, 11/27, etc (if I counted right.)
Without a lot of thought I suspect that the date, which can be formatted
as a week number, might end the need for the table an could be calculated.
Twice a month payments would also be doable this way.

Email me if no one else offers a solution as my time on this board has
been limited the last couple weeks.