Answered

Calculate date field based on another date

(0) Share

Report

Posted on by gjayne84

Hi everyone I am customizing a SharePoint list form using PowerApps and have so far been unable to do the following. I have two date fields - Date 1 and Date 2. When a user enters a date into Date 1 I want Date 2 to be automatically populated with a date that is 30 days after Date 1. Is this possible, and if so, how do I do it? Thanks in advance for your help.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Mike8 1,330 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello, You can try this: Datepicker2.DefaultDate = DateAdd(DatePicker1.SelectedDate,30,Days)
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @gjayne84,

Based on the needs you provided, I think the DateAdd function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

Set the DefaultDate property of the second DatePicker control to following:

DateAdd(DatePicker1.SelectedDate,30,Days)

On your side, you should set the DefaultDate proeprty of the DatePicker control within the Date 2 Data card to following:

DateAdd(DatePicker1.SelectedDate,30,Days)

More details about the DateAdd function, please check the following article:

DateAdd function

In addition, you could also consider take a try to set the OnChange property and OnSelect of the DatePicker control within the Date 1 Data card to following:

Set(PopulatedDate, DateAdd(DatePicker1.SelectedDate,30,Days))

Set the DefaultDate proeprty of the DatePicker control within the Date 2 Data card to following:

PopulatedDate

Best regards,

Kris
ninjasword341 2 on at

Like
a
(0)

Report
Copy link

Link copied!

This is great information. I have a different scenario I need help with, if anyone has any ideas

Three total fields for a device purchase date, years covered for warranty, and expiration date.

So basically if purchase date is 5/5/2020 selected from date picker, with a (2) for 2 years entered numerically in second field. I need the third expiration date in the third field to auto-calculate expiration date at 5/5/2022.

Any takers?
Benmo33 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, what should I do if my number of days will be different based on dropdown selected value?
for example: if my drop down selected value is ABC then add 14 days and if my drop down selected value is XYZ then add 30 days.

Thank you