It seems to me this expression has worked before, but for the life of me I can't figure out what is wrong with it.
"DueDate: IIf([CheckDate]<#3/31/2018#, DateAdd("m", 18, [CheckDate]), IIf([CheckDate]>#3/31/2018#, DateAdd("m", 24, [CheckDate]), Null))"
I want to add 18 months to any date in the CheckDate field that is before 3/31/2018 and 24 months (2 years) to any date that is after 3/31/2018 and I want to do it in a query based on a table. I don't get any errors it adds the 18 months fine but it adds it to all dates not the specified criteria. I've tried changing it to "yyyy", 24 to no avail.
Any help anyone can provide would be awesome!