Hey,
Someone sent me a query that had the following as an expression:
I was hoping someone might be able to explain what this is doing. I want to make sure I know how to set this up myself but I've been staring at it for 20 minutes and can't work it out in my head.IIf(DatePart("m",Now())-DatePart("m",[InvDate])<0,12+DatePart("m",Now())-DatePart("m",[InvDate]),DatePart("m",Now())-DatePart("m",[InvDate]))
Criteria: <>0
Thanks.