Change data when date interval of related dataset reaches certain value

Hey guys, I’m trying to change a dataset from no to yes when a different dataset date interval reaches a certain number/age. Here’s my database

Company dataset
Certain age = number

Customer dataset
Equipment = Equipment
Certain age = yes/no default no (want to change this when Equipment date interval is greater than Company certain age dataset)

Equipment dataset
Customer = Customer
Date interval = current date - manufactured date

What im trying to do is change the customer yes/no age dataset when the equipment date interval is greater than or equal to the company certain age number.

maybe use a scheduled backend workflow and schedule for a date that is corresponding to your company certain age

1 Like