Forum Discussion
UniversalAtlantic
Nov 04, 2020Copper Contributor
Need help with Date Formula
Hello,
I'm trying to use a calculated field and can't seem to get it right...
My List has an Expiration Column with a default date of 1/1/1973
- My calculated Column is expected to show 2 values
- ACTIVE (Expiration Date = 1/1/1973 or >= Today)
- EXPIRED
The following Formula is not working for me:
=IF(OR([Expiration Date]=1/1/1973,[Expiration Date]>=TODAY()),"Active","Expired")
As pictured below
- 1/1/1973 shows Expired (Incorrect)
- 3/1/2021 Shows Active (Correct)
- 10/31/2021 shows Expired (Correct)
I've also tried this formula with the same result =IF([Expiration Date]>TODAY(),"Active",IF([Expiration Date] = 1/1/1973,"Active","Expired"))
UniversalAtlantic sorry there was an error in my earlier reply now deleted. I'll post again shortly.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- RobElliottSilver Contributor
UniversalAtlantic sorry there was an error in my earlier reply now deleted. I'll post again shortly.
Rob
Los Gallardos
Microsoft Power Automate Community Super User