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?
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
@RandyHayes Thank you. My bad. Indeed, there's no error but the date picker seems rogue lol 🙂
..below
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.
@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
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.
WarrenBelz
223
Most Valuable Professional
MS.Ragavendar
110
stampcoin
99