Announcements
Hi all,
I have seeded short hand dates into power app from a SharePoint list. I have inserted a date picker with the SharePoint list being the source however the date is showing as 31/12/2050, regardless of the date. What am I doing wrong?
Thank you!
@Anonymous
What is the Format property of your DatePicker and what is the Language property of that same control?
Your Format property should be ShortDate and your Language property should be either empty (use the browser/app default) or the language code of your choice.
I hope this is helpful for you.
Hi Randy,
Yes the format is already short date and the language is blank .. any other suggestions ?
Yes, then it is using the regional settings of your device to determine how to format the data.
So, if you *always* want a specific language, then specify it in the Language property. i.e. "[en-US]"
Otherwise it will determine format by the device regional settings.
I have changed the language property as you suggested but nothing has changed.
Let me know if there is any more info I can send across to help get to the bottom of this!
Well, those are the basics! There should not be anything else impacting the display with a DatePicker - out of the box.
So, I am guessing something else might have been changed. What is the DefaultDate property and the InputTextPlaceholder property?
The default date is: Thisitem.targetdate
and the Inputtextplaceholder is: If(isblank(self.selecteddate),””)
Let's double check your control a bit.
Change your InputTextPlaceholder to:
If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language))
Change the DefaultDate to: Today()
See if that shows in the correct or if it is still incorrect.
Yes, that changes the date to today’s date. Although it has entered this date into all fields, including those which contain no data.
That's okay. It was only to test the format, not for use except to troubleshoot.
But...did it display as you expected or was it still the wrong format?
If it was the correct format, then tell me what kind of column targetDate is in your datasource.
And...what is your datasource?
The targetdate column is single line of text.. assuming this should be date/time? And the data source is excel. The dates are not actually showing up correctly in my SharePoint list, they’re showing up as for example 44498
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211
