Rounding date difference

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I got the following in my datacardvalue -

If (DataCardValue46_1.SelectedDate - Today() > 0, DataCardValue46_1.SelectedDate - Today() &" days till conclusion", DataCardValue46_1.SelectedDate - Today() & " days overdue")

However it displays "27.9583333333" days till conclusion.

How can I round it to 28 days?

thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @wonka1234

You can use Round() to round up you days.

Round(27.9583333333) // This will evaluate to 28.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@SpongYe
If (DataCardValue46_1.SelectedDate - Today() > 0, Round(DataCardValue46_1.SelectedDate - Today()) &" days till conclusion", DataCardValue46_1.SelectedDate - Today() & " days overdue")

does not seem to work

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @wonka1234

How is it possible to get decimals when your using dates?

I recreated your formula that is working for me without using Round.

What does this control returns DataCardValue46_1.SelectedDate?

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No