Help getting calculation to auto-update
I'm sure there is an easy fix to it, but I don't know it! Any help would be appreciated.
I have a calculation field that lists a member's "status" based on their date of expiration. The calculation reads below to fill the "member status" field:
IsEmpty ( member_expires_date ); "No";
member_expires_date < Get(CurrentDate) ; "Expired" ;
member_expires_date ≥ Get(CurrentDate) ; "Yes" ;
This works great if I go to the member status field and enter in a new date. However, when that date passes, it doesn't automatically reconfigure and change a members status to expired. Do I need to write a script to refresh that field and replace its contents on a daily basis? What would that script look like? Or is there just a button I need to click?