Reporting a number of days the status of a job was running between 2 custom dates.
I have fields for the following Job ID Status Start Stop At any time, I can get a request to count and report on my job days. My definition of a job day is a job that is running on that day ...
I can think of two options depending on the requirements.
1) If you need to have complete control over the date range every time you run the report, then set the date filters to <ask the user>
2) If you always need to count the job days during the previous "month" from the current day then create a Field that calculates the date that is a month before the current day and use that as your "is on or after" filter. The "is on or before" filter would be "current day".
The one month ago formula would be a formula - date field and would look like the following:
