How: Previous X days, including today

[BugDebug]

For reporting purposes, I would like to use the date filtering option "Previous X days", but that filter seems to exclude todays date. Is there a way I can get the last 14 days in a rolling window, including todays date?

I have checked timezones in both general settings and localization, that did not do the trick...

[HongTaiLang]

You can add criteria. This way you can include today, and the previous x number of days. The Logical Operator is AND. Please refer this article : http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/search-and-filter-comparison-types.html

[BugDebug]

You can add criteria. This way you can include today, and the previous x number of days. The Logical Operator is AND. Please refer this article : http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/search-and-filter-comparison-types.html

Perfect, solved my problem right away. Not sure how I overlooked that feature. Thanks.

[NailDyanC]

Hi Everyone,

Just to update this post. Here is the new and updated link for the article of search and filter comparison types: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/