AnsweredAssumed Answered

How many in the past year?

Question asked by EssexBiker on Apr 28, 2016
Latest reply on Apr 29, 2016 by disabled_morkus

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