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:

Show entries where [all] the following are true: [Entry Date] is [greater than] [last day of last month], and [Entry Date] is [less than] [first day of next month]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: "last day of last week"
  • "is before", value: "first day of 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")

Show entries where [all] the following are true: [Your Date Field Here] is [greater than] [last day of last month], and [Your Date Field Here] is [less than] [first day of next month]

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.