Date format issues - German vs English

(0) Share

Report

Posted on by TJO

230

Hi folks

I'd like to work with dates in german format, i.e. dd.mm.yyyy. When the user works with a browser in german all works well. However,

when the user uses an english browser, days and months are swapped.

For example, I've got a gallery where you can go to a detail screen and modify a selected record. This detail screen has a date picker where the item's date is preselected (see attachments). Here, in english the example record is from 9th October where in german it's 10th September. And the format is clearly set to "[$-de-DE]dd.mm.yyyy"

Any ideas?

Categories:

Building Power Apps

2020-09-10_13-56-...

2020-09-10_13-57-...

I have the same question (0)

All responses (6)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@TJO

Consider the following changes:

Set your Language property of the DatePicker to "de-DE".

Then change your DefaultDate to the following: DateAdd(Parent.Default, TimeZoneOffset(), Minutes)

Set your Format property to ShortDate

That should give you a consistent DatePicker with the language you want.

I hope this is helpful for you.

Was this reply helpful? Yes No
TJO 230 on at

Like (0)

Report

@RandyHayes Thank you, but that doesn't work. Setting the language property to "de-DE" leads to an error.
I've solved it by removing the format of the default date. However, I'm sure there will be issues coming again depending on the users settings.
Meanwhile, I've spent way too many hours on date time issues; I really hope that microsoft will straighten their **** out.

For example, for reasons unknown, users added records from 2022!? And it's quite unlikey that someone accidentally goes into a date picker clicks forward to 2022

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@TJO

What kind of error did you see setting the Language property? I checked that one out in a sample app before posting just to make sure you had a good answer.

Was this reply helpful? Yes No
TJO 230 on at

Like (0)

Report

..below

Was this reply helpful? Yes No
TJO 230 on at

Like (0)

Report

@RandyHayes Thank you. My bad. Indeed, there's no error but the date picker seems rogue lol 🙂

pa1.jpg

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@TJO

Yes, you have "de-DE" in your format...you want to put ShortDate in that.

Set your Language property of the DatePicker to "de-DE".

Then change your DefaultDate to the following: DateAdd(Parent.Default, TimeZoneOffset(), Minutes)

Set your Format property to ShortDate

Was this reply helpful? Yes No