Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting non-blanks
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00843742
Message ID:
00843746
Views:
27
>I have a report with multiple columns. One of the columns is a date field. I need to create a formula that will count the number of records in which that date is NOT blank. I've been looking through the functions lists and don't see an EMPTY or BLANK function in Crystal. How does one do this?

George,

How are you accessing the VFP data from Crystal? The reason I ask is because I use ODBC to get at the data and there is subsequently no such thing as an empty date as there is inside of VFP. A blank date comes back as 12/30/1899.

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform