>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