3 Replies Latest reply on Jun 8, 2010 11:07 AM by Mortalus2001

    Determine A Future Date Based On User Input?

    Mortalus2001

      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.