So I need a query to say "Yes" if a Date is Greater than another, this is what i got but its not working...
Expr1: IIf([MaxOf Installation Date]>[MaxOfContract Start date)]=True,"Yes")
This is showing "Yes" when the dates are
Install Date is 18/05/2021
Start Date is 05/03/2022
Expr1: IIf([MaxOf Installation Date]>[MaxOfContract Start date)]=True,"Yes")
This is showing "Yes" when the dates are
Install Date is 18/05/2021
Start Date is 05/03/2022