How to get a subtracted date displayed in date string?

  • davidgrayvideos
    Asked on February 3, 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

  • Kiran Support Team Lead
    Replied on February 3, 2017 at 2:24 PM

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

    How to get a subtracted date displayed in date string? Image 1 Screenshot 30

    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:

    How to get a subtracted date displayed in date string? Image 2 Screenshot 41

    Hope this information helps! 

     

  • davidgrayvideos
    Replied on February 4, 2017 at 7: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.

  • Boris
    Replied on February 4, 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.