Incorrect date format

[Mayank_Gupta]

I have column “Required Date” with datatype as “Date”. I have set the locale of my Spreadsheet and Appsheet Application as “English (UK)”. In my system, the date is shown in “dd/mm/yyyy” format. But in my client’s system (He is from New Zealand), it is showing in “mm/dd/yyyy” format. Does anybody know the reason for this. The client has tried this on his both his mobile application and browser. It is driving me nuts for past one week.

[khuslid]

Hi.
It is probably because of different browsers.
You can force the format by having a Viritual Column and in formula have:
DAY([Required Date] & “/” & MONTH([Required Date] & “/” & YEAR([Required Date]
In form, show the [Required Date], In detail/lists etc, show the new VC.
In showif [Req Date]: CONTEXT(“Viewtype”) = “Form” and in showif [New VC]: CONTEXT(“Viewtype”) <> “Form”

[Mayank_Gupta]

But it will still show the date in mm/dd/yy format when the user selects the date from date picker in form

[Steve]

The user’s device locale should be set according to the user’s preference. AppSheet tries to accommodate the user’s preference.

[Mayank_Gupta]

But the user is from New Zealand. His default settings are of dd/mm/yy

[Steve]

Is the user accessing the app as an app? Or through the browser?

[Mayank_Gupta]

He is accessing from both. And the result is same on both. I am going nuts on this.

[Steve]

The Chrome browser has a long-standing bug where it always uses the MM/DD/YYY date format in certain locations. I suspect (but do not know) that browsers based on Chrome (like Microsoft Edge) might suffer the same bug. If that’s what’s biting you, there’s nothing to be done. I have no explanation if the problem is affecting other browsers, or affecting the native app. I have to suggest you contact support@appsheet.com for further help with this.

[khuslid]

This is my experience as well.
That is why I suggested:
DAY([Required Date] & “/” & MONTH([Required Date] & “/” & YEAR([Required Date]
In form, show the [Required Date], In detail/lists etc, show the new VC.
In showif [Req Date]: CONTEXT(“Viewtype”) = “Form” and in showif [New VC]: CONTEXT(“Viewtype”) <> “Form”

[Mayank_Gupta]

Thanks man, let me try this

[Mayank_Gupta]

Thanks Steve