I am trying to do a count on a field called [Full Name] where the [Date Hired] falls within today() and last week. I was looking for some sort of adddays(today()-7). Is there a "last week" function?
This will give you the last 7 days
I hope it works
You have the function now(). You can put it in a variable and dimunuir seven days.
It is better to use today() instead of now() on the front end. So, replace max([Date Hired]) with today().
Retrieving data ...