Need help with Date Formula

[UniversalAtlantic]

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"))

[#2 · Accepted solution]

@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