Date Calculations: +1 month from today

  • Profile Image
    RogerYelvington01
    Asked on September 28, 2014 at 05: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!

  • Profile Image
    Ben
    Answered on September 28, 2014 at 06: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

  • Profile Image
    RogerYelvington01
    Answered on September 29, 2014 at 04: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?

  • Profile Image
    Jeanette
    Answered on September 29, 2014 at 07: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.

  • Profile Image
    Ben
    Answered on September 30, 2014 at 09: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

  • Profile Image
    Ben
    Answered on October 08, 2014 at 08: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