How to determine End_date from Start_date

[#1]

Hi Guys,

Please can any one help me to determine the end date of a contract from the start date? I only have the contract period in numbers such as a two year contract beginning 1/1/2015 has a contract period 24.See example below. So Please how can I determine the end date with thesame format as the start date in a Table in Qlikview based on the Contract_Period@@?

ID          Start_date               End_date                    Contract_period                        E.g End_date

1            1/1/2015                    ?                                      24                                       12/31/2016

2             2/10/2015                  ?                                       24                   

3             5/15/2015                   ?                                       24

4              6/10/2015                   ?                                       24

5               7/20/2015                    ?                                       24

Note: Date Format is "MM/DD/YYYY"

[#2]

Hi Clever,

I wanna thank you for your help. I tried it as a calculated dimension and it worked.

[#3]

Thanks Kim I did in the table and it worked.

[#4]

Hi Clever Please another question,

Now how can I label this column as End_date in the Table?

[#5]

Hi Kim,

Any idea how I can give the column a name. Since I added it as i calculated dimension i can figure out how to assign a label to it

[Anonymous]

Date(AddMonths(Start_date,Contract_Period),'MM/DD/YYYY') AS YourDesiredFieldName

[Anonymous]

Oh, sorry - I didn't see that you added as calculated dimension. You can only give it a label in each object. But really, do it in the script. Since this is a static value per row of data, it is just waste performing this calculation on each user interaction (even though cache will help some).