count number of records from a specific date

  • Thread starter Thread starter LBS
  • Start date Start date
L

LBS

I need to count the total number of records in a report for all records that
have a hiredate > the 12th of the month. I can't figure out how to
accomplish this. I need it to be for the 12th of the month of the current
month and year. Any help would be greatly appreciated
Thanks
LBS
 
You can try something like:
=Sum(Abs([HireDatd]> DateSerial(Year(Date()),Month(Date()),12) ))
The DateSerial() returns the 12th of this month.
HireDate>DateSerial() returns -1 if true
Abs() returns 1 if true
Sum(1) counts the number of true values in your report.

This expression can be in the Report or Group headers or footers.
 
Back
Top