Subtract two dates and bring the result in number for days

(0) Share

Report

Posted on by MIA27

working on power app for teams

In an edit form I have the following fields :

DateStart - user enters the start date

DateEnd - user enters the end date

TotalTakenDays - I want to keep disable the field to auto calculate after the above entry - the difference of days in between both the dates - Also to note that if the fields are blank , it will maintain 0

Reason of keeping 0 if any of the date field is blank, is that all the time dates are not available at the same moment, DateEnd info is received later.

please guide

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @MIA27

You can try to use this code :

If( DatePicker1.SelectedDate = Blank() || DatePicker2.SelectedDate = Blank() , 0 , DateDiff(DatePicker1.SelectedDate,DatePicker2.SelectedDate , TimeUnit.Days))

The result is as follows:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

On what property of "TotalTakenDays", I should keep the code to obtain the result

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi, @MIA27

In my understand , this is your "TotalTakenDays":

In my side , i just put this code in a Label - Text :

If( DatePicker1.SelectedDate = Blank() || DatePicker2.SelectedDate = Blank() , 0 , DateDiff(DatePicker1.SelectedDate,DatePicker2.SelectedDate , TimeUnit.Days))

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

In my case it should be in Card Value properties, I will take a try.
Thank you so much for your advise and your time.
Regards

Was this reply helpful? Yes No