Answered

Date Diff Calculation

(0) Share

Report

Posted on by WW-25090315-0

I have created a vacation request application for my office. I used the following command for date calculation, but when I select 5 days, the calculation box shows only 4 days. Can anyone help me correctly calculate the selected dates?

Code

DateDiff(DataCardValue66_1.SelectedDate, DataCardValue67_1.SelectedDate) 
 
Result

If you'd like help with the date calculation code, feel free to share it, and I can assist in troubleshooting!

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

TuongDoan 573 Moderator on at

Like (0)

Report

DateDiff returns the difference from the start date to the end date, excluding the end date. So, the result is correct. If you want to include the end date, simply add +1 at the end of the formula

---------------------------
|----- If the solution works, please kindly ✅ check the box "Does this answer your question?"

|----- This will help others in finding the solution more expediently 😄V

Was this reply helpful? Yes No
Suggested answer

Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

The DateDiff function calculates the days between the start and end dates, which excludes the start date itself from the count.

To include both the start and end dates in your calculation, you can add 1 to the DateDiff function as below

DateDiff(DataCardValue66_1.SelectedDate, DataCardValue67_1.SelectedDate) + 1

Hope this helps.

Thanks!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No
Verified answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (1)

Report

try this - DateDiff(DataCardValue66_1.SelectedDate, DataCardValue67_1.SelectedDate) + 1

Was this reply helpful? Yes No