Date Format

[Stelio_Pappas]

Hi all

This question follows on from a post I made yesterday

@Steve helped me understand the single quote meaning which I can see below in another experiment:

Using Steve's logic, the TestExpiryDate column (Q) above, is set to text (Format > Number > Plain Text), and the single quote circled in red is telling the sheet that although it really looks like a DD/MM/YYYY date, it should be treated as Plain Text. The column type is set at Text within appsheet also at this time.

If I change the formatting to date (DD/MM/YYYY) in the spreadsheet and the column type to Date in appsheet, I expect the single quote to not appear, however the trouble is appsheet won't commit the data. Instead the little orange "1" just sits there doing nothing in the app:

If I tap on the sync button behind the orange "1", I see the following error message:

After that I have to force stop, and clear cache & data to use the app again.

Can anyone think of why it won't accept the date?