Forum Discussion
ForrestParker
7 years agoQrew Cadet
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:
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:
AdjustMonth([Date],-1)