web

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

News and Announcements icon

Power Platform CommunityForums Power Apps If function with date

Power Apps

Answered

If function with date

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello guys,

I have an issue with the IF-function in PowerApps. I wish to make a Text item visible when the current date is later than the displayed date. Uitersteuitschrijfdatum is a column in a list, which contains dates. I've tried different formula's, the latest being this one.

If('DA - kl - datum'[@Uitersteuitschrijfdatum]<Today()-1, true, false)

Maybe it's better to derive the date from the text label in the app with the displayed date. This is what the displayed date ('S3_latest_subscribedate') looks like:

Does anyone know how to tackle this and what formula to use? Would be very helpful!

Have a nice day and kind regards, Mathijs

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try the below formula if it helps.

If(DateTimeValue('DA - kl - datum'[@Uitersteuitschrijfdatum],DateTimeFormat.LongDateTime) > DateTimeValue(Today()-1,DateTimeFormat.LongDateTime),true,false)

Was this reply helpful? Yes No
Verified answer

AJ_vizMan on at

Like
a
(1)

Report
Copy link

Link copied!

HI @Anonymous
I tested the scenario at my end
1. Created a text control name txtdisplaydate which contain value of Today()-3
2. Created another text control name txtCurrentdate with value of Today()

Then i added a button and on 'Visible' property of button used below code :
If(DateValue( txtcurrentdate.Text) > DateValue(txtdisplayeddate.Text),true, false)
It works fine at my end.

For your scenario, you can use any other control in place of button.

Was this reply helpful? Yes No

Join the conversation