What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to get a subtracted date displayed in date string?

    Asked by davidgrayvideos on February 03, 2017 at 12:51 PM

    I have tried to copy some methods from your forums but I cannot get any to work. I am wanting to calculate 90 days from a specific date and then display the date as a string.

    For example. A bride selects her wedding date, say 1/4/2019 and this date is displayed in a hidden field below as a date string (Friday 1st April 2019)

    I need to calculate 90 days from this date and display it in a date string so the bride knows what date the final payment needs to be made. This is a generic calculation which would apply to all customers when they select their wedding date.

    So it would calculate as 1/1/2019 and display as 1st January 2019 ( roughly )

    How do I get a selected date to show 90 days earlier basically?

    thanks

    x

    Page URL:
    https://form.jotformeu.com/davidgrayvideos/david-gray-videos-enquiry

  • Profile Image
    JotForm Support

    Answered by Kiran on February 03, 2017 at 02:24 PM

    You may change the equation in the calculation widget as shown below:

    Please note that the color brown and black in the formula acts as String and numeric functions respectively. You may click on each colored item in the formula to change the functionality. The above formula should be displaying the date as shown below:

    Hope this information helps! 

     

  • Profile Image

    Answered by davidgrayvideos on February 04, 2017 at 07:31 AM

    Thanks Kiran but the question is how do i get the date shown in the date string above ( Tue Jan 31 2017) to display 90 days earlier so it shows the date payment is required on (Tue OCT 30 2016)

     

    Whilst I do require the original date to stay as is, I need another hidden date string with the 90 days earlier string on it so I can put this as a placeholder in emails to inform the client this is final date by which all payments need to be made ie, 90 days before the date of the wedding.

  • Profile Image
    JotForm Support

    Answered by Boris on February 04, 2017 at 10:08 AM

    The solution my colleague offered provides the second date that is 90 days before the originally selected date.

    If you take a look at the screenshot my colleague posted, Your wedding date is May 01, 2017, while the calculation Date String of event shows 90 days earlier: Tue Jan 31 2017.

    Please try out the solution that my colleague recommended with using a Form Calculation and the dateString() mathematical function, and let us know should you need any further assistance:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Thank you.