web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Converting Text date t...

Power Apps

Answered

Converting Text date to DateTime form

(0) Share

Report

Report

Posted on by JohnB_13

13

Hey
How do I convert a date expressed as Text (Like this: "DD/MM/YYYY HH:mm") to Date and Time value?

In my case, I want to extract the most recent row of a connected Sharepoint list, the row with the latest date value in the column "Created" (default list column). However, the date shown in "Created" is in the form of Text and I need to convert it to Date and Time form to properly extract the most recent row of my list.

I tried the following code but didn't work:
Last(SortByColumns(ListName, "ColumnName", SortOrder.Descending))).

Thanks for any help

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
HI @JohnB_13 ,

Rather annoying that

DateTimeValue(YourText)

works fine for mm/dd/yyyy, but not for "the rest of us".

This should do the job

With( { _Split: Split( YourTextHere, "/" ) }, DateTimeValue( Index( _Split, 2 ).Value & "/" & First(_Split).Value & "/" & Last(_Split).Value ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation