I don't know if this is possible but it would be great it was. I have a lease form that I am trying to determine a future date based upon
a user choosing a date from a calendar. So as an example
User would pick from Drop Down List (Field 1) A lease of either 3, 6 or 12 months.
User then would pick a lease start date (Field 2) (say Jan 1, 2010)
Field 3 would then determine the proper Lease end date by calculating by whatever lease type (say user chose 6 months in this example from in Field 1) was chosen and calculating X days from the lease start date that was picked
Field 1 = 6 Month Term (Drop Down)
Field 2 = Jan 1, 2010 (Calendar Pick)
Field 3 = July 1st, 2010 (6 months Calculated from Field 2 chosen date+ lease length)
I would need to do this for the three types of lease lengths.
Any help would be GREATLY appreciated.
This is extremly close! Is there anyway to make it autopopulate the Lease End Date? As well as
put it in MM-DD-YYYY format?
I figured out the date format, I just to try and figure out how to have the 3rd field (Lease End Date) be automaticaly populated when a user picks a start date?