on 2023 Oct 26 12:11 PM
Hello Community,
I'm attempting to create a dynamic date filter within the advanced formula of a data action. My goal is to filter data from January of the current year through the next 12 months, starting from the current date. I've successfully implemented the second part of the filter, but I'm struggling to make the current year part dynamic.
MEMBERSET [d/Date] = "202301" TO NEXT(12, "MONTH", TODAY())
Request clarification before answering.
User | Count |
---|---|
10 | |
5 | |
4 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.