Forum Discussion

UniversalAtlantic's avatar
UniversalAtlantic
Copper Contributor
Nov 04, 2020
Solved

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

  • RobElliott's avatar
    RobElliott
    Silver 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

Resources