News and Announcements icon

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

Power Apps - Building Power Apps

Answered

If Statement on formula based on negative or positive date value

(0) Share

Report

Report

Posted on by wonka1234

909 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"

All responses Img

All responses (2)

Answers Img

Answers (1)

SpongYe 5,580 Super User 2025 Season 1 on at

Like (1)

Report
Re: If Statement on formula based on negative or positive date value

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.
Verified answer

TuxedoMask 21 on at

Like (1)

Report

Re: If Statement on formula based on negative or positive date value

Try This:

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