App show date format mm/dd/yyyy and google spreadsheet date is dd/mm/yyyy.
How can i make for the app show the data format dd / mm / yyyy.
All configuration is ok.
have records that the date is showing dd / mm / yyyy and others mm / dd / yyy in the same field.
First image
Home screen showing two different date formats
Second screen
Main screen showing two date formats
Third image
Date format is directly interfering with date to be recorded
That is strange! I’m afraid I don’t know what else to look at. I suggest you contact support@appsheet.com directly for help.
I’m trying to help a friend with the same problem. Did you find the solution ?
I manually changed all problem cells to the format dd/mm/yyyy and after changing the formatting of the column to dd/mm/yyyy after this the problem was solved
I am new using Appsheet and have the same date format problem. All spreadsheet and App locale settings match but the App keeps showing MM/DD/YYYY format. I need to show DD/MM/YYYY format in the App.
Help please.
Create a Virtual Column with the data type ‘TEXT’ and formula should be ‘TEXT([Date_Column],“DD/MM/YYYY”)’
Please check your default browser’s locale settings on your device. The language you prefer, needs to be at the top of that language list.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |