AnsweredAssumed Answered

Calculation for Approaching Due Dates

Question asked by SydneyBlock_1 on Dec 29, 2014
Latest reply on Dec 29, 2014 by Mark_M


Calculation for Approaching Due Dates


I am trying to create a calculation to tell when a vehicle's inspection is approaching, due and overdue. My problem is I don't know how to make my calculation decipher between the 3. I've tried a nested if function, but that returns all 3 values. Instead of showing one or the other, all 3 values come up if the function is equal to "overdue." Anyone have any tips on how to accomplish this?