Report that show count of records by Month using 2 date fields
Have a table with records that include a client Start Date and End Date. Want to make a report that shows a count per month of how many records for that month have a Start Date in or before that month and have an End Date after that month (or no End Date at all).
So record 1 - Start Jan 2020 End (none); record 2 - Start May 2020 End July 2020
Report:
Jan 2020 1
Feb 2020 1
Mar 2020 1
April 2020 1
May 2020 2
June 2020 2
July 2020 2
August 2020 1
Sept 2020 1
etc.
Can't seem to figure out how to do the set-up, calculations etc to make that happen - any ideas?