function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ivan WinzerIvan Winzer 

Getting Error for field...

So not sure what happened but today my formula field start to show errors for all records. Below is the code which should just produce a date in teh future due to the sign up date of the record. But now all records show an error can anyone see why this is happening with the code below.
DATE(YEAR(TODAY())+ 
IF( DATE(1900, MONTH(TODAY()), MAX(1,DAY(TODAY()-1))) > DATE(1900, MONTH( Start_Date__c ), MAX(1,DAY( Start_Date__c )-1)),1,0) , 
MONTH(Start_Date__c), MAX(1,DAY(Start_Date__c)-1))+1

The formula is to show the next year of the sign up date.
William TranWilliam Tran
Check the Start_Date__c,  is there a value there or is it empty or null?

if Start_Date__c is empty or null, then you likely will get an error.

Thx
Ivan WinzerIvan Winzer
Morning William,

The start date has a value of 8/27/2015. And this seem to be happening for all records. So i'll check to see if one record has a missing value but the start date is a required field so not sure how it could be blank.

Ivan