Add or subtract x years

I can’t find how I can filter only date values if date is less than x years from “now” or “today”.

To add years, I use the node Date/Time Shift (Legacy) and configure Shift value with the number of years I need …

The date format is yyyy-mm-dd.

Thank for your help

Hi @BDU , welcome to the community.

You can use the Date&Time-based Row Filter node:

You can play around with the duration:
Date-based duration: y: years, M: months, d: days
Time-based duration: H: hours, m: minutes, s: seconds

You can do -2y for example for 2 years ago, etc.


Thank you. I had tried but I didn’t add the letter of duration!..


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.