I have a date field (Last_Order_Date__c), in which I am defaulting the value of date to 6 months ahead from today's date.
Default Value for Above Date Field with formula
DATE( YEAR(TODAY()) + IF(MONTH(TODAY()) > 6, 1, 0), MOD(MONTH(TODAY()) + 6, 12), DAY(TODAY()) )
Right now it is defaulting the value correctly. Suppose today is 10/29/2016 .It is defaultly setting to this value 4/29/2017. My first question: Is this formula correct for defaulting the date value to the date which is 6months ahead. Will it also consider Months having 31st automatically? FYI I am getting below error if today's date is 10/31/2016 and I am using the above formula for default date.