Filter Formula Parameter Question to make report recurring:
I want it to recur every Thursday morning for the previous Monday through Sunday. I keep trying to make the date formulas but they keep failing. I have used
DateAdd(“d”,-10,today) and DateAdd(“d”,-4,today) as the formulas but that didn’t work for me, this is the original below before I changed anything. Can you help? The way I am doing it keeps failing. Thanks!
(If {RV_PB_PAYROLL_BOARD.NAME} = "Filled"
Then {RV_PB_PAYROLL_BOARD.START_DATE} <= {?End of Work Period}
Else If {RV_PB_PAYROLL_BOARD.NAME} = "Closed"
Then {RV_PB_PAYROLL_BOARD.ACTUAL_END_DATE} >= {?Start of Work Period} and {RV_PB_PAYROLL_BOARD.START_DATE} <= {?End of Work Period})