Discussions

Expand all | Collapse all

Formula Help; Start Date + Term = End Date

  • 1.  Formula Help; Start Date + Term = End Date

    Posted 10 days ago
    Edited by Ryan Parr 10 days ago
    I need help with a formula to identify and End Date.  Here are the three fields in play: 
    1. Start Date (Date)
    2. Term (Text Multi Select)
    3. End Date (Formula Date)

    The Term represents months, not days. And it's a multi select because we want its values locked. 




    ------------------------------
    Ryan Parr
    ------------------------------


  • 2.  RE: Formula Help; Start Date + Term = End Date

    Posted 10 days ago
    Edited by Austin K 10 days ago
    Your Term field is a Multi-Select field? As in multiple terms can be selected at one time inside the field? Or is it Multiple-Choice?

    Is there any other logic that needs to be applied here or are you just looking to find out what the end date is 3, 6 and 12(or whatever) months after the start date?


  • 3.  RE: Formula Help; Start Date + Term = End Date

    Posted 10 days ago
    Edited by Ryan Parr 10 days ago
    Doh! It's a Text Multiple Choice field. No other logic is needed.

    i.e. Start Date 1/1/20 + Term ( Let's say 12) = 1/1/21

    ------------------------------
    Ryan Parr
    ------------------------------



  • 4.  RE: Formula Help; Start Date + Term = End Date

    Posted 10 days ago
    Edited by Austin K 10 days ago
    If the terms are always in months you can do this inside the End Date field:

    AdjustMonth([Start Date], ToNumber([Term]))

    This will be blank until there is a Date and a Term selected. The above is also with the assumption that your multiple choice field is only numbers in there. If it is numbers and text like "6 months" this will need a different solution.



  • 5.  RE: Formula Help; Start Date + Term = End Date

    Posted 10 days ago
    Thanks, Austin!

    ------------------------------
    Ryan Parr
    ------------------------------