Hello all, I've exhausted my efforts and was unable to find my answer anywhere so far. I'm trying to get one of my database table columns to auto populate based on a calculated iif statement.
Iif ([test date] < Date() - 365, "Overdue", "Complete")
Date() is the current date I think.
So if the data in the test date column that's in the system is over a year old, I want this column to say Overdue. Otherwise say complete.