Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Expiration Date on Membership Database

Topic Labels: Formulas
240 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m working on a membership database for a non-profit. I would like to have a column that denotes if the account is Active (meaning paid membership within the last year) or Expired (not paid within the last year). I have an expiration date column already in the table, but am having trouble creating a formula that works. I know it’s something like "If expiration date is before today, “expired” is after, “active”. However I cannot get any of my attempts at formulas to work.Thoughts?

1 Reply 1

Try:

IF(
   {Expiration Date} < TODAY(),
   "Expired",
   "Active"
)