Determine if today is during payroll cycle
Hi everyone, thanks in advance for help!
I have a HR app that I maintain pay data in and one of the reports I generate is our bi-weekly payroll report so that our accounting team can process and...
Forum Discussion
I was looking at that function thinking that would be it. However, that works this week. How do I dynamically "shift it" every 2 weeks? So right now the anchor is 2003,2,11. Next Pay cycle that needs to shift to 2023,2,25
How do I keep it moving based on where I am?
------------------------------
Ivan Weiss
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendnp, use this function for FirstDayOfPeriod
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=43
The last day of the period will be 13 days later.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark, but it would not always be 13 days later. Depends which week I am in.
------------------------------
Ivan Weiss
------------------------------- MarkShnier__You
The last day of the payroll period is always 13 days after the first day of the payroll period.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Ivan,
This is a common problem. I build a Pay Roll Periods table . That way I have not just the start date and end date but when the calculations were done to send to the Pay Roll company.
------------------------------
Don Larson
------------------------------Don, so what do you do with this table? How do you get it to keep track of the next payroll cycle? Is it simply a single record with the last payroll and the next payroll being two weeks later? How do you update the first field? Maybe via pipeline?
Thanks!
------------------------------
Ivan Weiss
------------------------------
