You need to sign in to do that
Don't have an account?
Ivan 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.
The formula is to show the next year of the sign up date.
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.
if Start_Date__c is empty or null, then you likely will get an error.
Thx
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