Formula - dates greater then 3 yrs

[Jeffs23]

I have a field in my report called {Last Visit Date}.

What I would like to do is return a phrase if this field is greater the 3 yrs old. For Example, if the date thats returned to this field is : 04/01/2008, I would like it to return a phrase like "Greater then 3 yrs old" if its NULL or under 3 years then "Less then 3 years old"

 

[pmax9999]

Try:

If	IsNull({Last Visit Date})
Then	'Less than 3 years old' 
Else
If	{Last Visit Date} < Date(Year(CurrentDate)-3, Month(CurrentDate), Day(CurrentDate))
Then	'Greater than 3 years old'
Else	'Less than 3 years old'

Cheers
Pete