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

Outcomes