web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Incorrect date display...

Power Apps

Answered

Incorrect date displaying in app

(0) Share

Report

Report

Posted on by randomsky

110

I'm using SharePoint as the record source for a canvas app and the data I have in SharePoint for this record is:

But when I see the Date of Birth in the Canvas app, it shows this:

I'm not sure why the date incorrectly displays for the date of birth. Any help appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

shoog 2,164 on at

Like (0)

Report

The DatePicker has a property "StartYear", which is set to 1970 by default, which will cause any date before 1970 to show as 1/1/1970.
You would want to change that to an appropriate value.

Was this reply helpful? Yes No
randomsky 110 on at

Like (0)

Report

I tried changing the "startyear" property to 1940 but now it displays 7/6/1959 as the date of birth, which is still incorrect.

Was this reply helpful? Yes No
Verified answer

shoog 2,164 on at

Like (1)

Report
It seems most likely you are running into a formatting issue, since the example you show is dd/mm/yyyy in stead of the default American formatting.
This can be fixed by changing the Default property of your datepicker to something like the following (replace SPList.DateColumn with the name of your input and "nl-NL" to the country code you use to store the dates):
DateTimeValue(SPList.DateColumn, "nl-NL")

Was this reply helpful? Yes No
randomsky 110 on at

Like (0)

Report

Thanks @shoog , yes that resolved the issue

Was this reply helpful? Yes No

Join the conversation