Dynamic Date Filtering

[mystasz]

Hello, 

I have a dataset that ranges from April 2018 - April 2022. 

I need to split the data into two data sets. I got the first one, but can't seem to figure out how to do the second one. Any suggestions? 

1. Filter last 12 months (April 2021 - April 2022) 

2. Filter the 12 months, 3 years ago. (April 2018- April 2019) 

For the 1st one I did which filters the "Date" column for the last 12 months. 

datetimediff(datetimetrim(datetimetoday(),'month'),[Date],'month')
<= 12

AND

datetimediff(datetimetrim(datetimetoday(),'month'),[Date],'month')
>= 1

[IraWatt · Accepted solution]

Hey @mystasz,

I think this setup creates your 2nd dynamic filter (workflow attached): 

[RowCount] >= DateTimeAdd(DateTimeNow(),-4,"years") AND
[RowCount] <= DateTimeAdd(DateTimeNow(),-3,"years")

This will work assuming your using a date/datetime column type. Any questions on how this works make sure to ask :)

HTH,

Ira