web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps If Statement on formul...

Power Apps

Answered

If Statement on formula based on negative or positive date value

(0) Share

Report

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

Here is an example - Lets say DaraCardValue1 is 10/2/2023 and Today is 09/11/2023.

DataCardValue1.SelectedDate - Today = 10

What if DataCardValue1 is 09/09/2023

DataCardValue1.SelectedDate - Today = -2

How can I based an if statment based on - / + result?

ie: If DataCardValue1.SelectedDate - Today = Positive Value then "10 days till conclusion" Or

If DataCardValue1.SelectedDate - Today = Negative then "2 days overdue"

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

TuxedoMask 21 on at

Like (1)

Report
Copy link

Link copied!

Try This:

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

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

Like (1)

Report
Copy link

Link copied!
Hi @wonka1234

The DateDiff function returns the difference between two date/time values. The result is a whole number of units.

If( DateDiff(Today(), DateValue(DataCardValue1.SelectedDate)) > 0, DateDiff(Today(), DateValue(DataCardValue1.SelectedDate)) & " days till conclusion", DateDiff(Today(), DateValue(DataCardValue1.SelectedDate)) < 0, DateDiff(Today(), DateValue(DataCardValue1.SelectedDate)) & " days overdue" )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No

Join the conversation