How to conduct Calendar Month Validation on Bi-Weekly Payroll Calendar

Summary:

Content (required):

There is a business requirement where multiple claims of car allowances cannot exceed a certain amount per month. We already have a fast formula in place, but the current behavior is that it is doing all the monthly validation in a payroll month (Date earned) as we are on a bi-weekly payroll calendar. However, the requirement is to determine the monthly allowances validation in a Calendar Month (1st to 28/29/30/31st). How to achieve this requirement?

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):