New Voice

Question

Format a date calculated by formula

Forum|Forum|2 years ago
May 31, 2024
20 replies
485 views

I need to calculate and display a date 30 months from the date signed.

In my template, I have created a date signed field and called it policy_period_from.

I have created a formula field with the following formula: AddMonths( [policy_period_from] ,30)

This is displaying in numerical UK date format (dd/mm/yyyy) but we are sending this particular doc to our US customers so it either needs to be in US format (mm/dd/yyyy) or be in a format that can’t be misinterpreted in the US (e.g. dd MMM yyyy, i.e. 30 Nov 2026).

How can I achieve this?

eSignature

Show previous replies

C

Christopher.Alpizar

Docusign Employee

Hi @ser60,

I hope you are doing well.

If you enable the option to Allow users to set their time zone, do you get the same error?

Best regards,

Christopher | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.

S

ser60

Author

New Voice

Hi @Christopher.Alpizar - yes, I do

C

Christopher.Alpizar

Docusign Employee

Hi @ser60,

On your Regional settings do you see the section Date Signed Field?

Please see the image below:

Best regards,

Christopher | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.

S

ser60

Author

New Voice

Yes, I see it

C

Christopher.Alpizar

Docusign Employee

Hi @ser60,

I hope you are doing well.

Have you tried to change those settings to Account Default to confirm if the information displayed changes?

Best regards,

Christopher | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.

F

Farmfin

Newcomer

Hi @ser60,

I hope you are doing well.

Have you tried to change those settings to Account Default to confirm if the information displayed changes?

Best regards,

Christopher | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.

Hi Christopher, was this solved?

I have the same problem - went through the thread and followed your instructions but no results so far.

Best,

Clemente

J

Jenny.Martin

Community Moderator

Hello @Clemente,

I hope you’re doing well. Thank you for reaching out to the Docusign Community.

Formulas for dates are currently fixed in the mm/dd/yyyy format. Other users have also raised this concern, so an enhancement request has been created.

Enhancement requests are about adding a new behaviour to a specific feature. For this reason, their implementation is not guaranteed, as it depends on final decisions from our product and design teams.

Should you require any additional assistance, feel free to reach out. Thank you!

Best regards,

Jenny | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.

M

Mike5162

Newcomer

Has this been resolved yet? I have same problem when using add days formula, everything set to local however the formula result is mm_dd/yyyy despite the date it's calculating against being dd/mm/yyyy and everything at admin being set for dd/yy/yyyy. Very odd.

J

Jenny.Martin

Community Moderator

Hello @Mike5162,

Thanks for reaching out to the Docusign Community!

There is already an enhancement request regarding the date format on formula fields. However, at this time, there is no specific timeline for it’s implementation, nor is it confirmed whether it will be implemented.

We appreciate your understanding.

Best Regards,

Jenny | Docusign Community Moderator

J

Jenny.Martin

Community Moderator

Hello @Mike5162,

I hope you are doing well. I want to confirm if you need further assistance. Feel free to let me know, and I will gladly help you address the situation as soon as possible.

Best Regards,

Jenny | Docusign Community Moderator

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.