AnsweredAssumed Answered

How to calculate No of Records with no date

Question asked by HugoLidia on Jul 17, 2012
Latest reply on Jul 18, 2012 by philmodjunk

Title

How to calculate No of Records with no date

Post

We have a 10 records that have a "DateReceived" field and a "DateCollected" field, we want to be able to display a count of the records where the "DateCollected" field is empty.

Does not calculate correctly if using a statement like:

If(DateCollected <> " ", result1, result2) or  If(DateCollected > 0, result1, result2)

Outcomes