Date Calculations: +1 month from today

  • RogerYelvington01
    Asked on September 28, 2014 at 5:46 AM

    Hey Guys!

     

    Are you able to do Date calculations?

     

    IE:  IF someone signs a contract on todays date 9/28/2014, you could auto set a field to show that their first payment would be 1 month later and it would calculate 10/28/2014, and that the contract would be set to expire in 1 year, on 9/28/2014?

     

    Because each each month has a different number of days, I can't just put the date + 30 days.  Please advise, this would be very helpful!

     

    I don't have this to reference in a form yet, as I am just planning the layout for a new form.

     

    Thank you!

  • Ben
    Replied on September 28, 2014 at 6:44 AM

    Hi,

    Unfortunately at this time we are not able to use our calculations to do current date + 1 month, although + 30 days is possible. I will however try few things to see if we could do that using few different approaches and will keep you updated on that.

    In case we can not do such calculations, I will contact our developers to add this as a feature.

    Best Regards,
    Ben

  • RogerYelvington01
    Replied on September 29, 2014 at 4:47 PM

    maybe there could be certain conditional logic - that recognizes what months have 30, 31, and 28 days and then calculates the date accordingly?

  • Jeanette JotForm Support
    Replied on September 29, 2014 at 7:45 PM

    The system got controls to recognize months accordingly. However, this would require a deeper testing in order to find out if this scenario is possible.

  • Ben
    Replied on September 30, 2014 at 9:21 AM

    Hi,

    I just wanted to let you know that I am still looking at a possible solution for this and if it will not work properly I will raise this to our developers.

    As mentioned above the calculations for +30 days are possible, but I have one idea to see if it would be possible to count (similar to ) +1month as well and will update you.

    Thank you for being patient while we look into this.

    Best Regards,
    Ben

  • Ben
    Replied on October 8, 2014 at 8:02 AM

    Hi,

    I apologize for waiting, I wanted to update you on the status of this.

    I have tried working on what you wanted to achieve using several different date related and math widgets, but was not able to make it add + 1 month.

    For this reason I will raise this as a feature request to our developers. They will update you through this thread once they create a way to do that.

    Best Regards,
    Ben