function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rasmita Sahoo 11Rasmita Sahoo 11 

Create Validation on last friday of every month using Validation

VinayVinay (Salesforce Developers) 
Hi Rasmita,

When do you want validation rule to fire?  Below is the snippet for end date. 
IF(OR(DAY(Date_field__c) =28, DAY(Date_field__c) =29, DAY(Date_field__c) =30, DAY(Date_field__c) =31),true, false)

Please mark as Best Answer if above information was helpful.

Thanks,
Rasmita Sahoo 11Rasmita Sahoo 11
In every date it is throwing error. *Thanks,* *Rasmita*
Rasmita Sahoo 11Rasmita Sahoo 11
Yes Now this is working. Can you please explain, I am new in this platform. *Thanks,* *Rasmita*
Rasmita Sahoo 11Rasmita Sahoo 11
Hey, This is working on last day not Last Friday. Can you please help me.
VinayVinay (Salesforce Developers) 
I have updated can you try now and let me know?
Rasmita Sahoo 11Rasmita Sahoo 11
No this is not working. This question only for Last friday every month.
 
VinayVinay (Salesforce Developers) 
This is working in my org, can you re-check?
  
IF(OR(DAY(Date_field__c) =28, DAY(Date_field__c) =29, DAY(Date_field__c) =30, DAY(Date_field__c) =31),true, false)

User-added image
Rasmita Sahoo 11Rasmita Sahoo 11
Yeh, This is working for last day of every month. You entered lastday .. just enter any other month. you can see ..User-added image
Rasmita Sahoo 11Rasmita Sahoo 11
If you will found please let me know.. I tried from last 10 days. Thanks In Advance.