Date fields

[Patty]

I have to date fields, one is a proposed date the other is the actual
date. I want to count the total # of proposed dates that have an
actual date associated with it. Any help would be appreciated.
Thanks Patty

 

[Guest]

I assume you mean number of rows rather than number of distinct proposed
dates. Try something like this:

SELECT COUNT(*) As CountOfDates
FROM YourTable
WHERE ProposedDate IS NOT NULL
AND ActualDate IS NOT NULL;

Ken Sheridan
Stafford, England