Hi, trying to display the total count for a specific date field ('Date_Reported') where the date is between the last 7 days and current.
I'm able to get the total count but can't seem to limit it to the last 7 days.
what I currently have within control source is...
=Count([Date_Reported] Between Date() And Date()-7)
I'm able to get the total count but can't seem to limit it to the last 7 days.
what I currently have within control source is...
=Count([Date_Reported] Between Date() And Date()-7)