How to show only entries from the current day, week, month, or year
The Advanced Filtering extension allows you to filter using date ranges. To modify your filters: edit your View, scroll to the View Settings box and click on the Filter & Sort tab.
Show only Gravity Forms entries submitted last month
Thanks to the wonders of PHP relative dates, we can create filters that show entries only from this month like this:
To show entries from the current month, we do a little bit of mental gymnastics: instead of saying "show entries from this month," we tell Advanced Filtering to show entries that come between last month and next month. The filters shown are configured to show entries that are after ("is after") last month and before ("is before") next month.
To show only entries submitted this week
To show entries from last week, set Entry Date filters to:
- "is after", value: "sunday last week"
- "is before", value: "monday next week"
To show only entries submitted today
To show entries from today, set Entry Date filters to:
- "is after", value: "yesterday"
- "is before", value: "tomorrow"
This relative date technique will work for any Gravity Forms date field
You can use this approach with any Date field, allowing you to show:
- Deadlines that are approaching
- Fulfillment dates happening this week use (greater than "last Sunday" and less than "next Monday")
- Entries created today (greater than "yesterday" and less than "tomorrow")