Add or subtract x years

[BDU]

Hi,
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
Beatrice

[bruno29a]

Hi @BDU , welcome to the community.

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

Date&Time-based Row Filter

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.

[BDU]

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