I am extracting data from my Google calendar but AppSheet seems to inconsistently determine dates (I’m in UK) as a mix of USA and UK.
It looks like it may be based on APPSheet think dates are US, unless initiall xx/ is greater than 12 then is realises it is UK. So dates in May like 12/05/2018 are considered as 5th December 2018, but 22/05/2018 is understood to be 22nd May. This is verified by using MONTH() which shows a completely inconsistent date validation. Is this a bug, it seems to be a setting issue? Do I have a setting wrong somewhere?
Thanks
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |