Can Access calculate the current pa

[Bammer]

Can Access calculate the current pay period number on a bi-weekly based payroll year. Example of calc.-
Aug.24/01 is pay period #17. Since the number of current weeks is 34

(34/2=17). Can access actually calculate current # of weeks on current year?

 

[Bammer]

Hey Bammer,

Try this...

WeekOfTheYear: Int((Format([MyDate],"ww&quot/2)+0.5)

 

[MichaelRed]

First, you need to carefully define your terms. The data functions are quite capable of returning the "Week No" and since the payperiod number is just the weekNo / 2 it should be simple. BUT, if the pay period is just bi-weekly, you would need to adjust it when the accumulation of extra days gets to be more than 1/2 week. My experience with bi-weekly pyroll systeme is not very extensive, however I did run into the problem of the current years dirst paydate. The olny soloution I was able to devise was to essientially itterate from a KNOWN date, counting the pay-dates within the given year.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over