I have a date field (
datefield__c) that i want to subtract 11 months. How can I do this using formula in Process builder? I tried to use the below code:
DATE(YEAR(datefield__c), MONTH(datefield__c) - 11, DAY(datefield__c))
But when the month is Feb to Dec, the year doesn't subtract and also when subtracting dates from January 31, the value doesn't display because there's no February 31. Anyone knows how to fix this one?