Adding column when Date is more than 21 days old
Hello. I have a table names Contacts, and I would like to add a new column based upon the values of two other columns. If the column "Created Date" is older than 21 days from Today, the new column should populate with "Expired". If the column "Created Date" is not older than 21 days, it should return the current value in the Status column. I have tried IF ([CreatedDate] < TODAY() -21 Then "Expired" ELSE [Status]) and IF ([CreatedDate] < TODAY() -21, "Expired", [Status]) Any ideas? Thanks in advance.
