Date question

[celauritz]

I have a database where there is a modify date within it. Unfortunately, the database took a crap on itself for about a week and there are a number of accounts without this modify date. It just shows as blank. I want to count all these dates as "Done" if possible within this formula:

if {event.status}="1" then "PENDING" else
if {@Modified}>{@Due Date} then "LATE" else
"DONE"

I want to add something to the effect of:

if {@Modified} = "" then "DONE" into the formula, but it says that a date needst to be there. I also tried = (0,0,0) and < (1900,1,1) and both errored out.

Any suggestions?

 

[synapsevampire]

Since we don't know what @modified or @due date is, we can only guess.

Try:

if {event.status}="1" then
"PENDING"
else
if {@Modified} > {@Due Date}
and
not(isnull({@Modified}))
and
{@Modified} > cdate(1900,1,1) then
"LATE"
else
"DONE"

You may need to adjust the date within the cdate function.

If this fails, try posting all of the required information.

-k