how to add months/days to start date to get end date based on number of month/days picked in another column

(1) Share

Report

Posted on by Suchithra_A

Hi,

How can I add months/days mentioned in another column to start date to get end date.

I used below formula to get end date.

On Dafaultdate property of end date

DateAdd(DataCardValue4.SelectedDate,6,Months)

This is working fine.

But I am looking for the result as below,

I want to add number of months picked in the column " Internship/Contract Period" to start date to get end date.

How can I achieve this.

Kindly help me on this.

Regards,

Suchithra

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

ganeshsanap 1,555 on at

Like
a
(1)

Report
Copy link

Link copied!
You can create a variable to store the date value after adding the months you selected from dropdown. Add below formula on "OnChange" property of Internship period dropdown:

Set(endDate, DateAdd(DataCardValue4.SelectedDate, Value(DropdownDataCardValue.Selected.Value), Months))

Replace "DropdownDataCardValue" with the name of your Internship period dropdown name.

In the date picker for End Date, you then set its Default property to the "endDate" variable, so that when that month value is changed from dropdown, then the date displayed in the picker will be changed as well.
Reference: DatePicker Change Date Programmatically
Please click Accept as solution if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
PVosEska 329 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Suchithra_A ,

Could you try the following formula on your EndDate dropdown? I have testen it on my side and it works as expected:

DateAdd(DatePicker.SelectedDate,DataCardValue4.Selected.Value,Months)
DatePicker.SelectedDate = the startDate,
DataCardValue4.Selected.Value = the months you want to add ( If they choose the amount of months in the internship period field,
Months = the unit of measurement.

Hope this helps, let me know if you need more.

Regards,
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi@Suchithra_A,
Based on the issue that you mentioned, do you want to add a month number to StartDate in order to get the date from EndDate?
Could you please share more about your Internship/Contract Period, is it a Choice column?
@ganeshsanap provides the correct direction, however, DateAdd() expects the number value. You should convert Text value to Number value.
I have a test on my side, please take a try as below.
Set OnSelect property of the corresponding DataCardValue to the Internship/Contract Period ComboBox control as below

Set(EndDate, DateAdd(DataCardValue6.SelectedDate, Value(DataCardValue5.Selected.Value), Months))

Set the DefaultDate property of the corresponding DataCardValue to the End Date DatePicher as below

EndDate

Note:
DataCardValue6 is the corresponding DataCardValue to Start Date control,
DataCardValue5 is the corresponding DataCardValue to Internship/Contract Period ComboBox control
Please check the GIF for reference.
Best Regards,
Qi
AshROC 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Qi,

After following your method, i found out my EndDate is just adding the months. How do I solve this?