How to show only entries from the current day, week, month, or year

The Advanced Filtering extension allows you to filter using date ranges. 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 ("greater than") last month and before ("less than") next month.

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.