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?
|
