Forum Discussion
Find End Date from Same Column and Count Records
I'm working on an absence report with the below data set and would like to find the below First and Last Date of the sickness period so in the first set it would be First date = 30/03/2022 Last D...
Thank you for the response once again and its now even closer its now just that it is returning the count on the first and last day of the sickness period so in the first part of your example I am getting a count of 8 on 03/30/2022 and on 04/08/2022. Ideally I just want one return on the last date (04/08/2022) in this instance.