Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sumithra tamilselvan 9sumithra tamilselvan 9 

how to ignore three months of 2022 in validation rule \

How to ignore the three months(July, August, september)of 2022 and check Start_Date_TPI__c - TODAY()) < 31 for the upcoming months.
CharuDuttCharuDutt
Hii Sumithra
Try Below Validation Rule 
AND(YEAR( Start_Date_TPI__c ) = YEAR(TODAY()),Start_Date_TPI__c - TODAY()) < 31,
OR(MONTH( Start_Date_TPI__c )= 'July',MONTH( Start_Date_TPI__c )= 'August',MONTH( Start_Date_TPI__c )= 'September'))
######################################################
AND(YEAR( Start_Date_TPI__c ) = 2022,Start_Date_TPI__c - TODAY()) < 31,
OR(MONTH( Start_Date_TPI__c )= 'July',MONTH( Start_Date_TPI__c )= 'August',MONTH( Start_Date_TPI__c  )= 'September'))
Please Mark it As Best Asnwer If it Helps
Thank You!
SteveMo__cSteveMo__c
Are you trying to do something like this?
  
AND(
YEAR( Start_Date_TPI__c ) = 2022,
CASE( MONTH(Start_Date_TPI__c ),
07,1,
08,1,
09,1,
0 ) <> 1,
( Start_Date_TPI__c - TODAY() ) < 31
)