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 date function

Power Apps - Building Power Apps

Answered

date function

Like (0) Share

Report

Report

Posted on 14 Feb 2024 19:16:36 by neuronic

177

I have a text input control, myDateControl, in a Power App linked to Share Point lists. myDateControl is used for patching an SP list.

To extract the date from myDateControl, I have:

Date(

First(Split(newArtistDob.Text,"/")).Value,

Last(FirstN(Split(newArtistDob.Text,"/"),2)).Value,

Last(Split(newArtistDob.Text,"/")).Value

)

This always produces incorrect date, e.g. 02/01/2001 yields 24/06/1907

What am I doing wrong?

Thank you.

Categories:

Using Apps Using Formulas

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses Img

All responses (2)

Answers Img

Answers (1)

neuronic 177 on 14 Feb 2024 at 19:31:40

Like (0)

Report

Re: date function

Thank you, I suspected I was doing something stupid but couldn't see it. Yes, in fact, I should just use datepicker. Greatly appreciated, Thank you!

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,280 Super User 2025 Season 2 on 14 Feb 2024 at 19:23:20

Like (2)

Report
Re: date function

Hi @neuronic ,

The issue is that you have reversed the day and year arguments:

By swapping them, you get the correct output:

Date( Last(Split(newArtistDob.Text,"/")).Value, Last(FirstN(Split(newArtistDob.Text,"/"),2)).Value, First(Split(newArtistDob.Text,"/")).Value )

On a different note, why not use a datepicker control?

Was this reply helpful? Yes No