Not applicable

Date Control Validations

Jump to solution

I'm having trouble setting a validation between two date controls so that the min number of days between the effective from and effective to dates is 3 days and the maximum allowable is 90 days.

Tags (1)
0 Kudos
Reply
2 Replies
mlauer
Connector Crackerjack

Re: Date Control Validations

Jump to solution

a simple validation rule would help:

 

full text of condition:

or(date_from > date_to, or(dateFiddDays(date_from, date_to) < 3, dateFiddDays(date_from, date_to) > 90))

View solution in original post

0 Kudos
Reply
Not applicable

Re: Date Control Validations

Jump to solution

Thanks Manfred, this was very helpful!

0 Kudos
Reply