News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps date function

Power Apps - Building Power Apps

Answered

date function

(0) Share

Report

Report

Posted on 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

All responses Img

All responses (2)

Answers Img

Answers (1)

neuronic 177 on at

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

BCBuizer 22,262 Super User 2025 Season 1 on at

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?