Skip to main content
H
Hugh Cairns
Participant
September 2, 2016
Answered

Calculated dates - Adding days to a date field

  • September 2, 2016
  • 1 reply
  • 7092 views

I have created a mandatory field for the first signer to enter a date (isdate = MM/DD/YY).

{{  *date1_es_:signer1:isdate }}

I would like to add three days to the date the first signer enters - a calculated date that is not editable and a read only field.

I understand that I may need to use the dateAdd function

dateAdd(part, date, addition)

Adds the specified number of parts (e.g. "d" for day, "m" for month, or "y" for year) to a date to calculate a future date. You may use numbers or field names.

For example: dateAdd("m", "Jan 1, 2000", 3) would return a date of Apr 1, 2000. In this example, the formula adds 3 months to the date specified.

Can anyone suggest a solution for the required field?

I have mind block!

Thank you kindly

Hugh

    Correct answer Meenakshi Negi

    Hi EPDB86,

     

    Thank you for reaching out.

     

    We have checked that you are using the Adobe Sign Enterprise plan. The experts can best answer. Please contact our Adobe Sign Enterprise support team for the correct information. You may contact them using the steps in the following help document: https://adobe.ly/4cSUcBj.

    You may also refer to the information on the following help document: https://adobe.ly/4cRpdWj. 

     

    Thanks,

    Meenakshi

    1 reply

    R
    Community Manager
    Rijul Raj KhuranaCommunity Manager
    Community Manager
    September 5, 2016

    Hello Hugh,

    If you are looking to add 3 days to the current date/date on which signer opens the document, then you can use the now() and add three days into it:

    now()+3 would be the formula to be used.

    Let me know if you have any questions.

    Regards,

    -Rijul

    H
    Hugh CairnsAuthor
    Participant
    September 5, 2016

    Thank you Rijul.

    Yes, your solution works well for those who need to add 3 days from the day the signer opens the document.

    In my case, I need to add three days to a specified date.

    eg. I am a home inspector that performs a service on a specified date. I have a contractual obligation to provide a written report 3 days after the on-site inspection (the specified date).

    I have the first signer enter the specified date of the inspection - {{  *date1_es_:signer1:isdate }}

    I would like to add 3 days to that.

    Can you suggest a field that could do so?

    Thank you kindly in advance.

    M
    MelissaP31
    Participant
    October 3, 2016

    Have you tried:

    {{*date1_es_:signer1:isdate}}

    {{date2_es_:calc(date1 + 3)}}

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices