Count of dates in report, counts all, with or without date.

[MikeData]

Count of dates in report, counts all, with or without date.
In other words using count in a report, if there are 7 records in the criteria, will show 7 records.
If there are only 4 with date filled and 3 blanks one.
Here is the code used:
memb_count_for_famRec = count(famRec,grp->memb,grp->Detail)

How can I get only the count of records with dates filled only?
Any advise?

[madtowng]

Hi Mike,

My first thought is use SQL, it makes this so much easier.
My second thought is you probably have to use some kind of filter.
I don't know where you are using this particular code, but if you try
to generate a summary table, which will handle count, you will have the
option to include a filter than resembles .not. isblank("<dateField>")

[Al Buchholz]

Count() doesn't have a filter argument.

define a calculated field with a filter to determine if you want it to count.

If .t. then =1 , else =0

total the calculated field for the count.
__________________

famRecHasADate = if(.not. isblank("famRec"),1,0)

memb_count_for_famRec = total(calc->famRecHasADate,grp->memb,grp->Detail)

[MoGrace]

Anther suggestion: If your scripts/ reports need to use the date for a filter, you might want to consider adding a calc field to the table that converts the data using dtoc(yourdate). It is also handy for when you want to sort by date in an embedded browse because alpha sorts dates on the year first.

Oops, at least on the desktop...