Seems pretty simple, I need to filter data by same day different year. DATE_IN(DATE(@Date,"MM/DD"),"day") is not working as I had hoped.
Any help here is greatly appreciated.
Seems pretty simple, I need to filter data by same day different year. DATE_IN(DATE(@Date,"MM/DD"),"day") is not working as I had hoped.
Any help here is greatly appreciated.
Hi there,
Thanks for the post!
Setting this up will largely depend on how the rest of your data is configured and how you'd like this filter to operate. With that in mind, I can't offer an exact solution without some more context. However, if you're looking to filter your data such that only dates that match today's date but in different years, you could use:
DATEVALUE(TODAY(),"dd/MM")=DATE_CONVERT(@Dates,"yyyy-MM-dd","dd/MM")
Note that the "yyyy-MM-dd" should be replaced with your particular data's date format.
This formula would then be filtered on 'true' and only dates that match today's day and month will be returned.
I hope this helps! If you have any questions or require additional support around this, feel free to reach us at support@klipfolio.com.
Parker