Apr 06 2021 01:29 PM
I have a column "ExpirationDate" and I would like to automatically fill the "Expired" column with Y or N based on a fixed date.
I have tried several different calculation formulas, but they all say either Y or N, rather than correctly.
Example:
Fixed Date is 3/31/21
ExpirationDate-------Expired
3/1/2021------------------Y
4/15/2021-----------------N
Screenshot above showing the settings for the ExpirationDate column, if that helps...
Many thanks.
Apr 10 2021 09:00 AM
Solution