0-12 Months
13-18
Over 18 months
Code: Select all
Aging3: IIf(DateDiff("m",[Worker Start Date],Date())+(Day([Worker Start Date])>Day(Date()))<13,"0-12 Months",IIf(DateDiff("m",[Worker Start Date],Date())+(Day([Worker Start Date])>Day(Date()))<19,"13-18 Months","> 18 Months"))
How can I get it to recognize that 18 months + 1 day is >18 months?