Hi Adam, thanks for your input and though useful to know, Chrome is not the issue at hand - it really seems to be an AppSheet bug.
The data is taken directly from my Google Calendar “table” by AppSheet, no manual input. My Google calendar has been in use for many years and is definitely on UK region settings I just checked again and I work internationally and have no problem with many international calendar invites etc. It is a google apps account and is a “.com”.
Here’s an example: an entry of 11th April 2018, UK “11/04/18” (AA/BB/CC) is being converted by APPSheet on table load into “04/11/18” or 4th November (BB/AA/CC). I have verified APPSheets “confusion” by adding and displaying column fields of MONTH([Start]) and DAY([Start]). AppSheet incorrectly returns 11 (month) and 4 (day). You can see this flip-flop behavior in attached AppSheet data view. The date 11/04/18 is wrongly filed as 04/11/18 (in DD/MM/YY format!).
Dates where AA > 12 are loaded as UK, AA/BB/YY by AppSheet, when AA < 13 AppSheet files them as US BB/AA/YY instead. My money is on a minor AppSheet bug, it is reading my calendar config as USA somehow?
I am not sure how to proceed, if it’s a bug it’s one that will stop me from buying the product. I don’t want to pay for the product in order to raise a problem with the product that might not be fixed?
Very happy for someone to check my configuration.