Answered

Calculate datediff in days between two date fields in a form

(0) Share

Report

Posted on by ciprianpopovici

159

I have a Form with two dates fields, named From_picker and TO_picker. Also i create a button and a label outside the form. I test the formula bellow, where i create a variable that i assigned to a label to show the result. Unfortunately nothing is calculated and i don't know why.

If i used two fields that are not part of the form it's working...

Set(varDateDiff,(DateDiff(From_picker.SelectedDate,TO_picker.SelectedDate,Days)))

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ciprianpopovici
Check this will help you https://youtu.be/FbdGLVCvgRo

Was this reply helpful? Yes No
ciprianpopovici 159 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you for the tip, o look at the video , but cannot find a solution. All the examples are for "simple" fields, that are not part of a form. Like i say it's working when the fields are not part of the form. But if my date fields are part of a form and , i want to use that value outside the form .

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ciprianpopovici,

Do you meant that you have a button and a Label out of the form and they could not display the variable related the date differ?

Could you please share a bit more about your scenario?

I have a test and the situation is confirmed on my side that the Label out of the form display the variable as expected.

Try set the Label Text directly as below:

DateDiff(From_picker.SelectedDate,TO_picker.SelectedDate,Days)

Was this reply helpful? Yes No
ciprianpopovici 159 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
I try any version but with no luck. I create another screen , another form but still not show anything.
For testing , i add a form to a screen and outside the form i create a button and a label. I used both variants , with formula on label and with formula o button click.

i attached a screenshot, maybe someone can se why there is no value displayed.

Was this reply helpful? Yes No
ciprianpopovici 159 on at

Like
a
(0)

Report
Copy link

Link copied!

I attached a few screenshots with the button code and variable. The form is related to a SharePoint list.
Thank you

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ciprianpopovici,

That's so weird.😂

Would you mind creating a new form to restore it?

Or I think you should close the Power Apps app and try it later, sometimes that's how magic works.😅

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is the Formmode New or edit? if not try it as new that would clarify if issues exist with its Item. This can be an issue sometimes. If this works then this issue is usually makes the form not show values but show them in some places. It can be caused when there is no item or a blank item on edit form. Or if the form has not been ResetForm() onsuccess.

Was this reply helpful? Yes No
ciprianpopovici 159 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, i try your recommendations and it's working.
Thank you very much. Appreciate your help.

Was this reply helpful? Yes No