In my table, there few fields in which one of the field is called membership_start_date and there is another field called membership_expiry_date, which gets auto-filled using a formula.
The field status displays “Active” or “Expired” using a formula.
Here I also want the STATUS to display “Nearing Expiry” when there is only 15-1 day left for the membership to expire and I am not able to do this.
Can someone let me know how this can be done?
Please try
IFS([membership_expiry_date]>TODAY()+15, “Active”,
[membership_expiry_date]<TODAY(), “Expired”,
[membership_expiry_date,]<=TODAY()+15, “Nearing expiry”
)
Please test well. depending on your exact requirement, a minor adjustment could be required. For example, the above expression will furnish the following results. The dates are in dd/mm/yyyy format in the test app
Thank you…Thank you Suvrutt_Gurjar
It worked.
Thank you once again.
You are welcome.
Edit: a little more efficient expression will be
IFS([membership_expiry_date]>TODAY()+15, “Active”,
[membership_expiry_date]<TODAY(), “Expired”,
TRUE, “Nearing expiry”
)
Got it.
