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)