Skip to main content
Topics#Data ManagementSerena Shergill 的问题
Serena Shergill (PatSnap) 提问于 #Data Management
2018年5月18日 08:20

What would the formula be for an End Date field to be auto populated from the Start Date and a picklist Contract Length (months) field ?

I would like the Start Date (date field) and Contract Duration (picklist field in months) to autopopulate the End Date (date formula field) automatically.

 

e.g. once a User has inputted the Start Date as '1/05/2018' and the Contract Duration as '24 months' the End Date formula field will be filled in with the value '30/04/2020'

 

e.g. Start Date as '14/04/2018' and Contract Duration as '12 months' = End Date '13/04/2019'
10 个回答
  1. Serena Shergill (PatSnap)
    2018年5月18日 15:06
    Thanks All!

     

    Sunil's answer works best I have just added -1 to the end of the formula !

     

    ADDMONTHS( 

     

    Start_Date__c , 

     

    IF(ISBLANK(TEXT(Contract_Duration__c)), 

     

    NULL, 

     

    VALUE(LEFT(TEXT(Contract_Duration__c),2)) 

     

    ) 

     

    )-1
撰写回答...
0/9000