Date format issues - German vs English

Like (0) Share

Report

Posted on 10 Sep 2020 12:23:39 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:

General Questions

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

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

All responses (6)

Answers (0)

RandyHayes 76,287 Super User 2024 Season 1 on 12 Sep 2020 at 15:31:27

Like (0)

Report

Re: Date format issues - German vs English

@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
TJO 230 on 12 Sep 2020 at 02:52:45

Like (0)

Report

Re: Date format issues - German vs English

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

pa1.jpg
TJO 230 on 12 Sep 2020 at 00:21:47

Like (0)

Report

Re: Date format issues - German vs English

..below
RandyHayes 76,287 Super User 2024 Season 1 on 11 Sep 2020 at 20:20:11

Like (0)

Report

Re: Date format issues - German vs English

@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.
TJO 230 on 10 Sep 2020 at 17:57:05

Like (0)

Report

Re: Date format issues - German vs English

@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
RandyHayes 76,287 Super User 2024 Season 1 on 10 Sep 2020 at 13:45:41

Like (0)

Report

Re: Date format issues - German vs English

@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.