laguna92651

Portal Filter By Months Ahead Of Current Date

Discussion created by laguna92651 on Aug 29, 2017
Latest reply on Aug 30, 2017 by laguna92651

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.

 

All Dates

< 0 mos

0-1 mo

0-3 mos

3-6 mos

6-9 mos

9-12 mos

>12 mos

Outcomes