Question About Calculation

[Mortalus2001]

A previous forum user help me out by giving me this code:

form1.#subform[0].Term_Start_Date::exit - (FormCalc, client)

// Get the number of days from the epoch for the starting date

var startNumber = Date2Num(Term_Start_Date.rawValue,"YYYY-MM-DD")

// Add the lease term to the startNumber

var diff = startNumber + LeaseTerm.rawValue

// change back to a date

Term_End_Date.rawValue = Num2Date(diff, "YYYY-MM-DD")

This allows me to calculate a lease date based on start date and lease length. It works like a dream. My question is currently once I choose the lease term and the lease start date I must manually click on the Term_End_Date to have it populate properly. I have this code in the "exit*" section. Is there anyway to have the field auto populate once a user pick a begining date, essentialy eliminating the need for a user to click on the Term_End_Date field?

Thanks to the memeber's.

[Former Community Member · Accepted solution]

You could put it on the change event of the start date field. That will populate the enddate when a start date is chosen. Now if they decide to change the lease period after the start date has been selected the calculation will not fire..... is that acceptable?

Paul

[Mortalus2001]

Yes it works, I guess you have to live with some limitations...thanks!