problems with a count of nulls

[#1]

hi ...

i have an expression on a pivot table

=Count (if (date>=dateFrom and date<=DateTo), Field) //where dateFrom and DateTo are variables and Date the name of another filed.

and the count give me always 0.

i think is because the Field has NULLs. How can i filter the expression to don´t count the nulls??

if anybody thinks that the problem is another i am open to all the answers...

Thanks

[Miguel_Angel_Baeyens]

Then Set Analysis won't work. So gaoing back to conditionals, if your example returns zero or null, then some dates may not be correctly formatted.