Formula help

[jeffsturgeon2002]

Report Field (LastApptDate)

I want to take the CurrentDate - LastApptDate and if its Less than 1500 days, to produce an "X" or else nothing

The second part is CurrentDate - LastApptDate - if it greater than 1500 days to produce an "X" else nothing

[TripperDay]

I just started a new job and don't have access to anything yet, but if I had access to some data to test it, I think it would go something like this:

if DateDiff("d",LastApptDate,CurrentDate) >= 1500 then

"x"

else

""


or maybe like this:

if LastApptDate >= DateAdd("d", -1500, CurrentDate) then

"X"

else

""