web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to compare a today...

Power Apps

Answered

How to compare a today date with value in the text box date data

(0) Share

Report

Report

Posted on by MIA27

2

My Textbox value property is :

Text(ThisItem.SSRDate,"dd-mm-yyyy")

To change a color of rectangle background, on the fill property I am trying to use the below code :

If(BaseDataText_15<Today(),Color.Red,Color.Blue)

I want to be red background if the date has crossed today's date

Getting error

Please guide

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Ramanachiappan 179 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @MIA27 ,
Typically, when comparing dates in PowerApps, it's essential to ensure the correct data type is used. Therefore, you should utilize this approach.

If(DateValue(BaseDataText_15.Text)<Today(),Color.Red,Color.Blue)

Best regards,
Ramanachiappan M

If my response was helpful, please select "Accept as solution" to close the item. Your thumbs up would be highly appreciated if you found it useful. Thank you!

Was this reply helpful? Yes No
Verified answer

Static 118 on at

Like (1)

Report
Copy link

Link copied!

HI @Ramanachiappan ,

Try something like this
If( DateValue(Text(ThisItem.SSRDate, "dd-mm-yyyy")) < Today(), Color.Red, Color.Blue )
1. Text(ThisItem.SSRDate, "dd-mm-yyyy"): This extracts the date value from the text box and formats it as a string in the "dd-mm-yyyy" format.
2. DateValue(...): This converts the formatted date string into a date value that can be compared.
3. Today(): This function retrieves the current date
4. We compare the extracted date value from the text box with today's date using the < operator.
5. If the date in the text box is earlier than today's date, the rectangle fill color will be set to red (Color.Red); otherwise, it will be set to blue (Color.Blue).

Was this reply helpful? Yes No

Join the conversation