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 verify payroll.
Often we plan raises in advance and that is entered into our HR app but we do not want it to take place until that pay cycle.
So I am making a summary field that takes the last entry in the compensation table (most recent pay) as long as the effective date is on or before the pay date.
The challenge is how to know when my payment date is.
I have formula field calculating this coming Friday with the following code:
//Determine the Friday of this Week
LastDayOfWeek(Today()) + Days(-1)
So that should work by giving me today's date of 02/24/2023 but we are bi-weekly on payroll. By chance today is a pay date so that works. But if we were in next week the next pay date would be 03/10 but the formula would return 3/3.
How do I calculate that bi-weekly Friday date?
------------------------------
Ivan Weiss
------------------------------