You’re offline. This is a read only version of the page.
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.
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! 🍻
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
Hi @wonka1234
You can use Round() to round up you days.
Share
Report
All responses (
Answers (
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! 🍻
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
