Strange issue with calculated column containing dates

Occasional Contributor

Dear all,

 

I have an SP list with a date column ("Expiry Date)" and a calculated text column with:

 

=IF(ISBLANK([Current Contract Expiry]),"No Expiry Date",IF(Today>([Current Contract Expiry]),"No","Yes"))

 

The issue is that the formula does not seem to work in some cases only. E.g.: date is 31/07/2020 sometimes gives "Yes", sometimes "No".

shot.png

If I change the date to sometime else and then back it seems to work, but I need to make sure I understand why this is happening to avoid it in the future.

 

Any ideas?

 

Thanks,

 

Max

0 Replies