Using COUNT in query susmmary

vinsnash

I have a query that lists instances with a date. I want to count the dates that are > CURRENT_DATE.

I've tried

<p align='right'><b>Active: <<COUNT NSCPers.ExpireDate WHERE (NSCPers.ExipreDate > CURRENT_DATE)>> </b></p>

but this only displays the expression as is. I'm clueless with HTML. Can anybody show me the correct syntax?

Vins Nash

tford

You can't do the calc in HTML. You have to store the results of the calc in a BO attribute, then display the attribute value in the HTML cell.

vinsnash

Thank you.

I finally saw that caveat where you can't count using an attribute only BO instances. I changed the 1st NSCPers.ExpireDate to simply NSCPers and it counted the whole BO not just the query result.

There is a report available that does the same thing. Just thought it would be handy as part of a query result.