Regarding date validation

Question

Hi,

We have 2 objects named seller and invoice. Let's make a month into 2 parts as 1 to 15 and 16 to 31. The seller and invoice have a lookup relationship. If we entering data on the seller object from date 1 to 15 then the invoice date must only be before 1 to 15 that is before month 16 to 31. It should not enter future dates. Or else if we entering data on the seller object from date 16 to 31 then the invoice date must be before 16 to 31 which is the same month 1 to 15. That is a condition so kindly help me in developing validation rule for this.

Thanks and Regards,

Virat

Shirisha Pathuri · Answer

Hi Virat,

Greetings!

You can actually try by adding the If condition to check the date field to see,if it is in between 1-15 and then the values should be between 16-30 value of last month.

Likewise,you can add an another statement to check the same for 16-31.

Kindly let me know if it helps you and close your query by marking it as best answer so that it can help others in the future.

Warm Regards,

Shirisha Pathuri

Regarding date validation

Formulas

관련 학습

도움 더 받기