You need to sign in to do that
Don't have an account?
Ivan Winzer
Month or Day out of range in DATE() function
So had this error sometime last year and now getting it again. For some reason today i started to get #Error# in my formula field that has the below code:
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
Not sure if this has to do with the leap year but for some reason it started erroring out again. Now the start date field is required to create the record so there are no blanks. Any have an idea on why this happened again and how i can get it to stop.
The main focus of this query is to show the customers next anniversary date from the time they started the membership.
Ivan
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
Not sure if this has to do with the leap year but for some reason it started erroring out again. Now the start date field is required to create the record so there are no blanks. Any have an idea on why this happened again and how i can get it to stop.
The main focus of this query is to show the customers next anniversary date from the time they started the membership.
Ivan