web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Rounding date difference
Power Apps
Unanswered

Rounding date difference

(0) ShareShare
ReportReport
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)
  • SpongYe Profile Picture
    SpongYe 5,715 Super User 2026 Season 1 on at

    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! 🍻

  • wonka1234 Profile Picture
    wonka1234 920 Super User 2024 Season 1 on at

    @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

  • SpongYe Profile Picture
    SpongYe 5,715 Super User 2026 Season 1 on at

    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.

    SpongYe_1-1708642475132.png

     

    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! 🍻

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans