Dumb Head here again, sorry, I have exhausted almost all the combinations of search strings and my trusty books!
All I am trying to do, with little success , is to calculate how many absences a staff member has had during the past year ( 365 days) It needs to be dynamic based on the current date.
It needs to be dynamic based on the current date, in other words, those more than a year ago, fall off and aren't included.
I have and Absence Start Date ( date field) and that's all I will be basing the count of absences on.
Dynamically I am trying to find the count of the start dates during the past year, using the system date ( Get date)
First correct answer received a post card from Sunny (not) Blighty
All the best x