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.
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โ
But it will still show the date in mm/dd/yy format when the user selects the date from date picker in form
The userโs device locale should be set according to the userโs preference. AppSheet tries to accommodate the userโs preference.
But the user is from New Zealand. His default settings are of dd/mm/yy
Is the user accessing the app as an app? Or through the browser?
He is accessing from both. And the result is same on both. I am going nuts on this.
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.
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โ
Thanks man, let me try this
Thanks Steve
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |