Expand my Community achievements bar.

Determine A Future Date Based On User Input?

Avatar

Level 3

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

Example

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.

3 Replies

Avatar

Level 3

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?

Avatar

Level 3

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?