How to get a subtracted date displayed in date string?

  • Profile Image
    davidgrayvideos
    Asked 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

  • Profile Image
    Kiran
    Answered 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
    davidgrayvideos
    Answered 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
    Boris
    Answered 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.