web

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

News and Announcements icon

Power Platform CommunityForums Power Apps date function

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
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
neuronic 177 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation