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
Solved! Go to 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