# Auto Calculating Dates w/Conditions

• 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

• 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!

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

Hi,

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

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.