payroll date range
I have a little issue with selecting a date range. I currently have a portal tool on each employee record (their info etc) from the payroll file. Any hours log on the payroll table will show on the employee table through the portal tool. I want to be able to sort this information each pay period. our pay periods run on two weeks. so i would like to have something that says EVENT_DATE [IS MORE THAN OR EQUAL TO] 3/2/15 *for example* [BUT IS NOT MORE THAN] 3/15/15. I am using a simple date formula now but when i tried to do NO MORE THAN i am running into a problem.
THE FORMULA I HAVE NOW IS
EVENT_DATE => 3/2/2015 (OR THE DATE WHERE THE PAY PERIOD STARTS)