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)