B
Bobbye R
The state requires a report of "weekly" gross wages earned for unemployment.
This company pays twice a month (26th thru 10th is paid on the 15th) and
(11th thru 25th is paid on the last day of the month). My table contains the
employeeID, gross wages and the pay dates.
I need to determine the number of weekdays (Monday thru Friday) in any given
pay period and determine the ADG "Average Daily Gross" for that pay period.
Also, I would like to use 2 paramenters. One to enter the date range the
state requires and the other to enter the employeeID of the person in
question. Example follows.
The state wants to know the weekly earnings of John Smith starting Monday
10/20/08 and ending Sunday 01/18/09.
Gross Pay Date
$1000 10/31/08 (10 days ADW 1000/10=100)
$1200 11/15/08 (11 days ADW 1200/11=109.09)
$800 11/30/08 (11 days ADW 800/11=72.73)
The results looks like this:
Weekly Pay Period Gross
10/20/08-10/26/08 $500 (100*5)
10/27/08-11/02/08 $545.45 (109.09*5)
11/03/08-11/09/08 $545.45 (109.09*5)
11/10/08-11/16/08 $400.01 (109.09*1+72.73*4)
Any help would be greatly appreciated
This company pays twice a month (26th thru 10th is paid on the 15th) and
(11th thru 25th is paid on the last day of the month). My table contains the
employeeID, gross wages and the pay dates.
I need to determine the number of weekdays (Monday thru Friday) in any given
pay period and determine the ADG "Average Daily Gross" for that pay period.
Also, I would like to use 2 paramenters. One to enter the date range the
state requires and the other to enter the employeeID of the person in
question. Example follows.
The state wants to know the weekly earnings of John Smith starting Monday
10/20/08 and ending Sunday 01/18/09.
Gross Pay Date
$1000 10/31/08 (10 days ADW 1000/10=100)
$1200 11/15/08 (11 days ADW 1200/11=109.09)
$800 11/30/08 (11 days ADW 800/11=72.73)
The results looks like this:
Weekly Pay Period Gross
10/20/08-10/26/08 $500 (100*5)
10/27/08-11/02/08 $545.45 (109.09*5)
11/03/08-11/09/08 $545.45 (109.09*5)
11/10/08-11/16/08 $400.01 (109.09*1+72.73*4)
Any help would be greatly appreciated