Hello everyone,
Ever since I began working with Appsheet, I’ve been experiencing the following date format problem, which, to me, looks like a bug. The issue occurs as following:
1. I need of my dates to be displayed in European style: DD/MM/YYYY.
2. My data source, namely the worksheet I am using, is set with Locale → Romania, Time zone->Bucharest.
The worksheet shows the date correctly:
3. Back in Appsheet, all of my tables are set to Romania:
4. The app displays my dates in US format:
Am I missing something?
To avoid confusing my users, I set the dates to be displayed in long format, but the long format is, you know, long 
. I would really much like the dates to appear as they are in the worksheet.
Thanks in advance for your help!
You could convert it into that format by using a virtual column then displaying that where the users view the date.
I don’t know when appsheets will update these methods for y’all to use your proper formatting, but they are heading in the right direction as we recently got right to left formating. So Appsheets is expanding for use cases in other countries besides here in the US
Yes, I thought about this, but I would like to be able to use the column as date, not as text, for filtering purposes.
You will have to do the filtering on your side using the original date columns(Building actions and formulas), but display to the user the virtual column.
I have faith in them that things will get better and better. The whole Appsheet experience is constantly improving. In the meantime, I’ll be waiting in line here for the European date format 
.
1 Like
