Auto Calculating Dates w/Conditions

  • Profile Image
    RogerYelvington01
    Asked on October 23, 2014 at 12:34 AM

                                      

    1 Year

    1 Year PIF

    Free Month

    Join Date:

    10/20/2014

    10/20/2014

    10/20/2014

    First Draft:

    11/20/2014

    11/20/2015

    11/20/2014

    Expiration:

    11/20/2015

    11/20/2015

    12/20/2014

    Enhancement:

    04/15/2015

    04/15/2016

    04/15/2015

    Term:

    12 months

    12 Months

    13 Months

     

     

     

     

     

    2 Year

    2 Year PIF

    Free Month

    Join Date:

    10/20/2014

    10/20/2014

    10/20/2014

    First Draft:

    11/20/2014

    11/20/2016

    11/20/2014

    Expiration:

    11/20/2016

    11/20/2016

    12/20/2016

    Enhancement:

    04/15/2015

    04/15/2016

    04/15/2015

    Term:

    24 months

    24 Months

    25 Months

     

     

     

     

     

    M2M

     

     

    Join Date:

    10/20/2014

     

     

    First Draft:

    11/20/2014

     

     

    Enhancement:

    04/15/2015

     

     

    Term:

    Open End

     

     

     

     

     

     



  • Profile Image
    RogerYelvington01
    Answered on October 23, 2014 at 12:39 AM

    I want to be able to create auto calculations, based off of the following examples in the table:

     

    1 Year Contract

    1 Year Contact Paid in Full

    2 Year Contract

    2 Year Contract Paid in Full

    M2M (month to month contract)

    ----------------------

     "Free Month" will add one month to the expiration

     

    I've tried to do it in the attached form, but I'm having the issues working through the conditional logic to get it to play in an actual use case scenario.  And ideas or suggestions would be helpful, thank you!

     

     

  • Profile Image
    jonathan
    Answered on October 23, 2014 at 08:07 AM

    Hi,

    I need to ask more details to understand the actual requirements you need.

    I checked  your jotform http://www.jotformpro.com/form/42916390730960.

    Can you describe what needs to be calculated? 

    Was it suppose to be number of days/months/year between 2 dates?

    You can calculate date difference similar to this form template http://www.jotform.com/form-templates/calculate-number-of-days

     

    If Days can be counted, then its possible to determine months(30 days) or years(365 days).

    After getting the auto calculated number of Days.. you can then use the number to calculate amount/price.

    Hope this help. Please inform us if  you need further assistance.

    Thanks.