Nov 24 2020 04:03 AM
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