I have a missing timecard report. It runs by payroll end date. I am trying to include the last paid date to determine if the employee needs to be inactivated. If I put the {PaidDate} in the report it list all of the check dates. I have been trying a formula:

if {PaidDate} < {PREndDate} then {PaidDate} else " "

I am receiving the error " " requires a date.

Thank you.
Runner

Thank you for your help. I used the second formula and the return is the first date in the series. I am looking to return the latest check written.

Runner