datetime filters on report subcription

It will be based on the dates you entered at the time of the subscription. I'd set the default property value to a macro like {% DateTime.Now.AddDays(-30) %} or something of the like and see if this gets you the results you're looking for.

Initially I did use the macro as the default date and time, but when I created the subscription it set the parameters to the dates and not the macro so I wasn't sure if it would work when the report sent every 2 weeks. I ended up just coding it into the sql query. In our 12+ years of using kentico we've never sent reports automatically so i wasn't really sure how it would work.

Name the parameters in your report FromDate and ToDate (the names are important) and set the data type to Date and Time for both. As the default values for the parameters, you can use the macro Brenden mentioned and for today {% DateTime.Now %}.

When you create a subscription for that report, the FromDate and ToDate parameters are not visible in the subscription parameters. But every time a subscriber receives an email, the macros are reapplied.

As I look back in our last report subscription we created, we used sequel statements directly in our sequel query that seem to give us the best result.