1 of 1 people found this helpful
In these cases it's best to lay all of the relevant calculations out in a table and see where the unexpected results appear. In this case create a table with:
[HiredDated] >= [BetweenDateStart] AND [HiredDate] <= [BetweenDateEnd] (see if TRUE or FALSE is returned)
[Date Of Leaving] <= DATEADD('day',90,[HiredDate]) (see if TRUE or FALSE is returned)
([Date Of Leaving] <= [ReportingMonthDate] (see if TRUE or FALSE is returned)
Also put your 2 calculated fields in the table and you should be able to see where the calculation is returning results you don't expect to see.
Thanks Andrew - drilled down into the data and found the issue and it was with the data set rather than the calculation.
Added a couple of additional clauses (i.e. checking if the leave date was null) as well just to ensure the calculation runs only when I have a valid start and leave date.