I'm struggling with the logic to add a date filter to a portal. I currently have a portal that I am filtering with 3 different global fields, all work fine.
I would like to add a field to filter by a months block from current date. There is a sale date column in the form of 8/29/2017.
The date drop down filter field would have the following entries. The filter will be referenced to the current date.
If 3-6 mos were selected only records in Dec 2017, Jan 2018 and Feb 2018, 3, 4 and 5 months from today's month.
< 0 mos