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.