To be scientifically literate is to empower yourself to know when someone else is full of shit.-Neil deGrasse Tyson

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network Access AI Bot ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

 Home > TechHelp > More...DirectoryRequest List Access >
 Stacey Doucette         5 months ago
Is there a function that returns a number between 1 and 26, identifying the biweekly pay period for each date of a calendar year?  Or, is there another way to accomplish this?  I am working on a reference table that lists all dates for 2024 and the corresponding pay period, but wondered if there is an automated way to accomplish this.
 Kevin Robertson             5 months ago How are you adding the dates to the table? What does your table structure look like?
 5 months ago You could take the Week of Year number and just integer divide it by 2.
 Stacey Doucette         5 months ago I have one table that contains a date field and a pay period field. In the date field, I list each day of the year in mm/dd/yyyy format (1/1/2024, 1/2/2024, etc through year). In the pay period field, I list the number (1-26) corresponding to the payroll date, for example 1/1/2024 - 1/14/2024 might be '1', 1/15/2024 - 1/21/2024 might be 2 and so on (depending on pay date), until I have grouped all dates into their appropriate payroll period. The idea is to join this table to a transaction table, by date field, so that I can match the date to the corresponding pay period.  I am building a cash flow system.
 5 months ago How do you determine the pay period? Is it based on the first day of the year? First full week of the year? There are a lot of different methods for determining "the first week of the year" from an accounting standpoint.
 Stacey Doucette         5 months ago I am starting with 1/3/24, because its my first pay period of 2024.  I am building this for my own use.
 5 months ago Right, but if you want to codify it in your database for future years, we need a rule to use for your algorithm.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in TechHelp.