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


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?





0 Replies