Rolling Filters Ranges

[rdeguzman]

I have expiry dates for documents. I am looking to create filters that dont ever have to have the ranges changed manually.

Today's date to 1 year from now.

AND

Today's date and 8 months from now to the end of the that 8th month.

Thoughts anyone?

Thanks for the help in advanced.

[rdeguzman]

I found the answer that worked and figured since I did it myself I should post it. its already built into the filter tool, but I had to actually try and use the Custom Filter. 

[Visa Max Date] <= ToDate(
DateTimeAdd(DateTimeNow(), 1, "years")
) AND
[Visa Max Date] >= DateTimeNow()

[grossal · Accepted solution]

Hi @rdeguzman,

you could use this formula in a Filter Tool to achieve it:

[Date] >= DateTimeAdd(DateTimeToday(),1,"years") AND DateTimeAdd(DateTimeAdd(DateTimeFirstOfMonth(),20, "month"),-1, "days") >= [Date]

 This calculates the Filter ranges based on today's date. I think you might need to make it to "21" month instead of 20, but that's it.

Workflow with the formula attached. Let me know if I got it right.

Best

Alex

[rdeguzman]

@grossal yes that did work as well.

Thanks!