function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sreenathsreenath 

Need only 4 dates should be entered in a date field as a specific payment dates

Hi developers,

 

                      I need only to get 5,10,15 & 20 value of dates must be valid. other dates should not be valid in a date field for user entry.

 

eg: i can enter 2/5/2012, 2/10/2012, 2/15/2012, 2/20/2012 only.other dates should not be allowed

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,

 


Try the below Validation rule:

 

NOT(DAY(StartDate) =5 || DAY(StartDate) =10 || DAY(StartDate) =15 || DAY(StartDate) =20)

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.

All Answers

Navatar_DbSupNavatar_DbSup

Hi,

 


Try the below Validation rule:

 

NOT(DAY(StartDate) =5 || DAY(StartDate) =10 || DAY(StartDate) =15 || DAY(StartDate) =20)

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.

This was selected as the best answer
sreenathsreenath

Hi Jain,

                 No words to say very thankful to you. I am thinking it in conditional format but not in negational format. 

If you can help me in another issue please take a look at below issue.

 

salesforce custom object record data is merging in official PDF document using one app in salesforce. we are not creating that PDF, its a standard govt. issued one. My requirement is record data should be in uppercase in PDF. But not in that record. This is for looking good purpose.

 

 The app which I am using is Drawloop for merging data into any type of documents.