web

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

News and Announcements icon

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

Power Apps - Building Power Apps

Answered

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

Like (0) Share

Report

Report

Posted on 5 Jul 2021 13:19:44 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:

Using Apps Using Formulas

General Questions

All responses Img

All responses (2)

Answers Img

Answers (1)

CarlosFigueira on 05 Jul 2021 at 14:25:29

Like (0)

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

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

BCBuizer 22,264 Super User 2025 Season 2 on 05 Jul 2021 at 13:40:14

Like (0)

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

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