Using the Termination Date value for counts between Calendar Month Start Date & Calendar Month End
I have read a lot of posts where individuals have been looking to get counts of employees who have a termination date between X & Y. However, if an employee has a termination date on the last day of the month the "time"."date" or "Time"."calendar month start date" is for the following month. I have tried utilizing filter using with no success. Is there any way to bypass this pre-built logic to meet business needs?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):