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 nothingI 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
""
No comments:
Post a Comment