Back to Docusign.com
Is there a way to create a Text field that will automatically calculate “Date of Birth” to 18 years or above?
Solved
Text field validation
+5- Troubleshooter
Best answer by JohnSantos
Yes, you can achieve this in DocuSign by using Formula fields to build formulas based on date fields in your documents. When the recipient completes the underlying fields, the Formula field automatically calculates and displays the result.
Here’s a high-level overview of how you might set this up:
- Create a Text field for the Date of Birth input.
- Validate this field as a date.
- Create a Formula field that calculates the difference between the current date and the Date of Birth field. You can use the DateDiff function for this.
- The DateDiff function calculates the number of days between two dates2. To convert this to years, you might divide by 365.25 (accounting for leap years).
- Finally, you can create a condition in the Formula field to check if the calculated age is 18 or above.
You can find more information here Calculating Days and Dates (docusign.com)
+19- Guru
- Answer
Yes, you can achieve this in DocuSign by using Formula fields to build formulas based on date fields in your documents. When the recipient completes the underlying fields, the Formula field automatically calculates and displays the result.
Here’s a high-level overview of how you might set this up:
- Create a Text field for the Date of Birth input.
- Validate this field as a date.
- Create a Formula field that calculates the difference between the current date and the Date of Birth field. You can use the DateDiff function for this.
- The DateDiff function calculates the number of days between two dates2. To convert this to years, you might divide by 365.25 (accounting for leap years).
- Finally, you can create a condition in the Formula field to check if the calculated age is 18 or above.
You can find more information here Calculating Days and Dates (docusign.com)
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.