Legacy User

Solved

Date Format in Data Field

Forum|Forum|10 years ago
October 6, 2015
6 replies
390 views

I have templates with a few data fields masked as date fields to be used for contract start and end dates. The entry format for those fields always defaults to MM/DD/YYYY regardless of the date format settings under Time Zone. I would like to have the custom date fields formated to look more universal like MMM DD YYYY (i.e. Oct 6 2015).

Any idea how to accomplish this? Thanks!!

eSignature

Best answer by Community Expert

Hello,

When using a (https://www.docusign.com/support/classic/documentation/cdse-user-guide/docusign-tags/docusign-tags#DataField) Data Field or (https://www.docusign.com/support/classic/documentation/cdse-user-guide/docusign-tags/create-tag) Custom Tag witha a Date Mask:

t he tooltip will recommend that the signer enter the date as MM/DD/YYYY, but this is NOT enforced when using any date formats that include month text. (e.g. 10 Nov 2015 or November 10 15) Although the Tool Tip will say that it is an invalid date, it will allow the signer to complete signing.
The MM/DD/YYYY IS enforced when using an all numerical date format. It will not let the signer enter a date that is not in MM/DD/YYYY (e.g 15 /10/2015 , 15/10/2015 are blocked)

*If you are familiar with (https://support.docusign.com/answers/00001589) Regex , you may be able to use the Text Mask with a Custom Regex Pattern, to create the desired format.

Please Note: This is not to be confused with our (https://support.docusign.com/answers/00002637) Date Signed Tag, that supports multiple formats.

I hope this helps.

**If you create a format with a custom Regex Pattern, please share with the community below.

C

Community Expert

Answer

Docusign Employee

Hello,

When using a (https://www.docusign.com/support/classic/documentation/cdse-user-guide/docusign-tags/docusign-tags#DataField) Data Field or (https://www.docusign.com/support/classic/documentation/cdse-user-guide/docusign-tags/create-tag) Custom Tag witha a Date Mask:

t he tooltip will recommend that the signer enter the date as MM/DD/YYYY, but this is NOT enforced when using any date formats that include month text. (e.g. 10 Nov 2015 or November 10 15) Although the Tool Tip will say that it is an invalid date, it will allow the signer to complete signing.
The MM/DD/YYYY IS enforced when using an all numerical date format. It will not let the signer enter a date that is not in MM/DD/YYYY (e.g 15 /10/2015 , 15/10/2015 are blocked)

*If you are familiar with (https://support.docusign.com/answers/00001589) Regex , you may be able to use the Text Mask with a Custom Regex Pattern, to create the desired format.

Please Note: This is not to be confused with our (https://support.docusign.com/answers/00002637) Date Signed Tag, that supports multiple formats.

I hope this helps.

**If you create a format with a custom Regex Pattern, please share with the community below.

C

Community Member

Legacy User

If you want only the format date : mm-dd-yyyy, you may use this regex :

^(0[1-9]|1[0-2])-([1-9]|[12][0-9]|3[01])-(\\d{4})$

DocuSign

C

Community Member

Legacy User

Here is something for yyyy-mm-dd, which is common in Canada and probably elsewhere. It accepts Feb 29 in any year but it would be pretty easy to add a bunch more to cope with Feb 29 every 4 years in the 20th and 21st centuries.

^19|20\\d{2}-((01|03|05|07|08|10|12)-(([012]\\d)|30|31))|((04|06|09|11)-(([012]\\d)|30))|((02)-(([012]\\d)))$

C

Community Member

Legacy User

Ooops. Posted that too soon - it allowed for 00 days!

^(19|20\\d{2})-(((01|03|05|07|08|10|12)-((0[1-9])|([12]\\d)|30|31))|((04|06|09|11)-((0[1-9])|([12]\\d)|30))|(02-((0[1-9])|(1\\d)|(2[0-9]))))$

C

Community Member

Legacy User

UK - date format

Hi there,

I have inserted a text field on the doucemnt and validated as date format but it takes US date format. However, I want to change the date fomate to UK format as DD/MM/YYYY.

Please can you assist me to use Custom option to bring UK date format.

Thanks

C

Community Member

Legacy User

Welcome to the Community Ashok, I have merged your discussion with a previously answered discussion. Please view the best answer above and Elite Registrations comment on how he gets the british format. Thanks for visiting the community.

Sign up

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.

Docusign 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.