cancel
Showing results for 
Search instead for 
Did you mean: 

Filter date with dynamic year - advanced formula

rabab_mansouri
Discoverer
0 Kudos
165

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())

Accepted Solutions (0)

Answers (0)