5 answers
Date__c (Field user enter date as 08-06-17 )Copy__C(Output need to be 31-05-17)I have tried with formual field also :IF(MONTH(Date__c) < 12,IF(DAY(Date__c) > 10, Date__c, DATE(YEAR(Date__c), MONTH(Date__c)-1,30)),IF(DAY(Date__c) > 10, Date__c, DATE(YEAR(Date__c) + 1, 1, 30)))but iam getting output as 01-05-17 i need to be 31-05-17