App show date format mm/dd/yyyy and google spreads...

Dev_TI · 09-12-2019 07:56 AM

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.

Steve

Dev_TI

All configuration is ok.
have records that the date is showing dd / mm / yyyy and others mm / dd / yyy in the same field.

Dev_TI

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

Steve

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.

matheus_lopes1

I’m trying to help a friend with the same problem. Did you find the solution ?

Dev_TI

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

ControlAS

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.

ManiKumar_V

Create a Virtual Column with the data type ‘TEXT’ and formula should be ‘TEXT([Date_Column],“DD/MM/YYYY”)’

Aleksi

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.