Strange issue with calculated column containing dates
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? Thanks, Max
