Calculate number of days

  • Profile Image
    selvecchio85
    Asked on March 20, 2014 at 01:51 PM

    I tried using the new calculation widget, but my results are not coming out correctly can you help?

     

    I would like to calculate what the date is from a given date minus 180 days.

    Input Date - 180 is what I'm using, but it gives me a static number not a date. How can I display what the date is?

  • Profile Image
    Cesar
    Answered on March 20, 2014 at 04:18 PM

    Unless my colleagues have any other input. I do believe this is how the calculation field currently functions. As it does not perform date formatting.

    I will go ahead and raise a ticket to the Dev Team so that they can further review the possibility of addind this ability on to the calculation widget. Now, I cannot promise such feature will be implemented nor can I provide an ETA for when this takes place. In any case I believe it is best for the Dev Team to review your input.

  • Profile Image
    grade4pagasa
    Answered on February 22, 2016 at 12:35 AM

    Hi selvecchio85. 

    I noticed that your ticket is still open / pending and not updated after 708 days since you asked this question. Were you able to find an answer? 

    Here's a simple form that will subtract 180 days from the date you entered. The output will be in dateString format (Wed Aug 26 2015). 

    A lot of updates on widgets took place since the time you created this thread. 

    Hope this helps. 

    - Randy, fellow JotForm user.

     

  • Profile Image
    Jan
    Answered on February 22, 2016 at 04:38 AM

    Thank you for sharing your knowledge @grade4pagasa in regards to the calculation, it is very helpful. This escalated ticket has been tagged as resolved already by our developers.