Hello,
Trying to create formula field to validate age age 18 years or above and when I used the Datediff and created date of birth filed and today’s date but I keep getting the below error message, any recommendation on the correct steps?
The formula would need to look like this:
if(DateDiff( [DateSigned1] ,[Date of Birth])>=6574,1,0)
Using the Date Signed field for todays date (data label is “DateSigned1”) and a text field with date field validation (data label is “Date of Birth”). The conditional logic will show the “Over 18 years” field when the value is 1 and the “Under 18 years” field when the value is 0. The formula field color is set to White, so it is invisible. I forgot to make the two outcome fields “read only”, I would recommend to do that as well.
Outcome with same date 18 years ago:
Outcome with other date, under 18 years:
Important: Due to leap year, in the formula 6574 or 6575 days could actually mean 18 years.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Back to Docusign.com
