I have a field called [date expires] and I want to create a field to display 'expired on' if the date is past, and 'x months' if the date is not yet reached.
My plan involved creating a lot of extra fields.
- [days until expired] , which will convert to
- [months until expired], which will plug into
- [expiration description], which would display 'Months until Expired' if date is not past, or 'Expired on (Date)' field
But I'm having trouble figuring out how to convert days number to months, and I'm not sure that this is the most elegant method.