Help with bi-weekly ending date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am updating a database that is used for time tracking of my employees.
Their pay period is on a bi-weekly basis. What I would like to do is have
the query for my Main form automatic populate the date and also change when
the current period end on Saturday. There is someone that can help with this.
Thanks in Advance
 
I am updating a database that is used for time tracking of my employees.
Their pay period is on a bi-weekly basis. What I would like to do is have
the query for my Main form automatic populate the date and also change when
the current period end on Saturday. There is someone that can help with this.
Thanks in Advance
Click to expand...

Since biweekly work dates can stumble over holidays (what if the last
day of the current pay period falls on Christmas?), you may want to
just build a little 26 row per year table with the pay period dates.

John W. Vinson[MVP]
 
Back
Top