Search results

Full expression is: Insp Date: CDate(IIf([RFA MAIN].[PermitExtension]="3 Months",DateAdd("m",13,DateSerial(Year([rfa main].[DATE RET'D TO CUST]),Month([rfa main].[DATE RET'D TO CUST])+1,0)),IIf([RFA MAIN].[PermitExtension]="6 months",DateAdd("m",16,DateSerial(Year([rfa main].[DATE RET'D TO...

Good Afternoon, Long time lurker, first time poster... I have a query where I used the expression builder to determine an inspection date based on 10 months after a permit date, but also taking into account whether there is an extension or not. My expression goes something like this...