Help with date formula

[mudflap]

if {Prepress WIP (B.Due Date} = currentdate then
"Due today"
else "not working"

That is the formula I am using. But I want it to print out
how many of the values in that field are over date. Plus it never seems to work..Always prints out the else field. Even though there are dates that are due today..

Thanks
PEter

 

[dgillz]

You need to create a running total field to do a conditional count of the items where teh datefield is not equal to the current date.

Your formula looks fine to me. If you browse the data in the date field, do you see the dates that are not the currendate? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com