Report of applications completed in last month - dynamic dates?
Content
Hi,
How do I set a filter for a report scheduled for monthly delivery that will return only those applications that were completed in the last month? I was trying to pull in dynamic date objects as the 'between' values for Application Completion Date, but it's not working. I tried between "1 month ago" and "Current date", and "1 month ago" and "Beginning of this month", with the expectation I would just schedule for delivery on the first of the month in the early AM. However, these don't work, I get an error message.
Can anyone suggest a solution?
Thanks!
Traci