web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to convert MM/DD/Y...

Power Apps

Answered

How to convert MM/DD/YYYY date text into Date object?

(0) Share

Report

Report

Posted on by Dave Wi

Hello,

I have date text in format MM/DD/YYYY as "07/02/2021"

I require to evaluate, if "07/02/2021" is greater than today.

How can I do that, for some reason following formula throws null value for label, therefore I am unable to evaluate - can you help?

Text(DateValue("07/02/2021",DateTimeFormat.ShortDate))

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You can use:
DateDiff(Now(),DateValue("07/02/2021"))>0

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
If you know that the date will always be in the "mm/dd/yyyy" format, you can pass the second parameter to the DateValue function that specifies which locale it will be used (for example, "en-US" uses that format). You can then compare that date with Today():

If( DateValue("07/02/2021", "en-US") > Today(), "July 2nd is greater than today", "July 2nd is not greater than today")

You mentioned that the formula that you have is having an error; that is because the second parameter to the DateValue function is the language to use when converting from text to dates. The DateTimeFormat enumeration can be used to as a parameter to the Text function.

Was this reply helpful? Yes No

Join the conversation