We take Annual Maintenance Contract (AMC) for computers and that is valid for 365 days.
I have 4 Columns:
AMC Start Date of Type Date
AMC End Date of Type Date
AMC Days (Difference between Todays Date and AMC End Date) of Type Number with App Formula ( IF ( [BT] = AMC Bill, HOUR ( TODAY() - [AMCStartDate] ) / 24, “” ) ) which means if the Bill Type (BT) is AMC Bill then find the difference in days of today and AMC Start Date
AMC Status of Type Yes/No
I have put this formula in App Formula of AMC Status Column: IF ( ( [AMCDays] <= 365 ), [AMCStatus] = NO, [AMCStatus] = Yes )
NO and Yes are written as Expired & Active in the Yes/No display Values
If AMC Days value is Less than or equal to 365 the AMC Status shows: Active and if it is more than 365 it shows Expired.
Above is working but I have to manually go to every entry edit it so that it refreshes
How to I refresh the AMC Status without manually clicking on edit on every entry?
For example every day at 12:01pm it should automatically check all entries and update the Status to Active OR Expired automatically by running that App Formula for every Row.