Back to Docusign.com
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?
Solved
Formula Field
+1- Newcomer
Best answer by Michael.Rave
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.
+19- Docusign Employee
- Answer
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.
- Community Moderator
Hi
I hope you are doing well.
I would like to confirm if you were able to solve your issue by utilizing the solution that was suggested?
If so, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find.
Otherwise, feel free to let me know and I will gladly help you address the situation as soon as possible.
Best regards,
Alejandro R. | Docusign Community Moderator
"Select as Best" below if you find the answer a valid solution to your issue!
Sign up
Already have an account? Login
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationDocusign Community
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.