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
""
Thursday, March 29, 2012
Formula help
Labels:
currentdate,
database,
field,
formula,
lastapptdate,
microsoft,
mysql,
nothingthe,
oracle,
produce,
report,
second,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment