I have a column that formats the date and extracts only the day. In the database it looks correct, 17.
When I try to display that field with a text field, it does not appear.
The system thinks that instead of 17/02 DD/MM it is 02/17 MM/DD, and since the month 17 does not exist, it breaks.
If I change the date to 12/02, it works.
Do I have to do anything special with the formatting?
I wouldnât rely on the date plugins, especially if you use dd/mm/yyyy format.
I would just use a math column with this formula instead:
DAY(Date)
mmm, Iâm new in Glide and Iâm trying to not âhackâ the css, html, to prevent future crashes. But that list of special column types are not reliable? I thought that since they were already available they were part of the core of the system.
Itâs right, itâs another bug of this plugin using an non-US format date.
Your plan B as Jeff wrote is to use a Math column instead.
Saludos!
try to use it in the template column first
itâs a good thing I realized⌠thank you!
Hola de nuevo!
If your browser is set to US English, the values are shown on screen perfectly. This plugin is a headache working with non-US formats . 
I think @SantiagoPerez can take it and report this annoying issue.
Chao
Another thing, thats in the system column, not in the plugin âfomat dateâ
How can I change the date in the first row to: â11 marchâ in the admin panel?
If I type â11/3â it converts to â3 novemberâ, and if I type â3/11â stays in november tooâŚ
Iâm starting to get desperate, Iâve spent all afternoon just to get a tab to show me the events of a specific day. As you can not directly (rare) I finally discovered that there is a column that you can filter and extract the day. Then it turns out that it has a bug. And now I canât change a date from the database. My God 
I know what you mean (suffer) 
Glide uses the US format to work with dates (internally) but your APP uses your browserâs format date to show data.
If both formats are different and you want to manipulate date values manually in GDE (editor), use the Date picker component in order to have the right value in cell otherwise, you will face the troubles you are describing.
Just typing 11/3 is a little ambiguous. If you are manually typing in a date, I would at least type it in yyyy/mm/dd format, or just spell it out as November 3. Glide is remarkably good at converting text to dates. You can even type in â3 months from nowâ and it will give you the actual date 3 months from now.
I have a similar problem, whereby on Android device it shows dd/mm/yy but on iOS it shows mlm/dd/yy.
This was using the Math and Template column.
Sometimes the computed columns doesnât even appear!
Formatted dates will show differently based on whichever region/locale that the device is set to. That could be a setting in the OS and/or the browser. Are you sure that both the android and the iOS devices are set to the same region/locale?
When you say that the computed column doesnât show sometimes, which type of column are you referring to specifically?
