AnsweredAssumed Answered

Two Week Pay Period Calculation Flipped in 2017

Question asked by user28271 on Jan 31, 2017
Latest reply on Jan 31, 2017 by philmodjunk

Hi all....

 

I have a client that has a two week pay period.  I wrote a calculation to set the period and it has worked perfectly for the last 6 years.  Until now.

 

Starting in 2017 is period has flipped. It was a simple thing to adjust,  but I am confused as to why this happened.  So I am looking for opinions.

 

What is my calculation you ask?

I have a system Preference table with two date fields: Week 1 and Week 2.  Admin enters a sample dates for week 1 and week 2.

 

System calculates whether the weeks are Odd or Even and then use that from then on.

 

Mod ( WeekOfYear ( Week1 ) ; 2 )

 

Fo the last six years week one was Even and week two was Odd.  Now they have flipped.

 

Comments welcome (including a better way to do this)

Outcomes