Date Function

[Robbydobbs]

I am trying to write an If statement saying that if the year of the vehicle is less than 10 years from the current year date, then show exempt. This is what I have:

If Year(n_year) < status (currentdate),-10, "EXEMPT".

But for some reason I can't figure out how to say less than 10 years. In other words if the year is 2003 and the year of the car is 1992, then show Exempt.

Could someone help me with this?

[jamesooooo]

I would think you would say something like :

if year(status(currentyear)) - n_year < 10 , "EXEMPT"

[Fitch]

Status (currentdate) -10 will give you ten DAYS ago, not 10 years. (Also, you have an extra comma in there.) Try this:

Case ( n_year < (Year ( Status (CurrentDate) ) -10), "EXEMPT")

[Robbydobbs]

Thanks a lot you guys. It worked Great!!!