# Something is wrong with Date Format mm/dd and dd/mm **URL:** \ **Category:** Ask for Help\ **Created:** [February 17, 2022, 6:23pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636 "2022-02-17T18:23:42Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Saul\_Delhom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saul_delhom/32/39097_2.png) [@Saul\_Delhom](https://community.glideapps.com/u/Saul_Delhom)\ **Post date:** [February 17, 2022, 6:23pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/1 "2022-02-17T18:23:42Z")
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? ![Captura de pantalla 2022-02-17 a las 19.18.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af2dc88298b58f8853594e514e387f9ee6ac4409.jpeg) ![Captura de pantalla 2022-02-17 a las 19.18.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8d56650ce401662db061ebec107d745062f39216.jpeg) ![Captura de pantalla 2022-02-17 a las 19.18.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bcde611bbb38f6b66b164193de6fc55a3f14d793.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 17, 2022, 6:38pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/2 "2022-02-17T18:38:36Z")
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)` ---
**Author:** ![Saul\_Delhom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saul_delhom/32/39097_2.png) [@Saul\_Delhom](https://community.glideapps.com/u/Saul_Delhom)\ **Post date:** [February 17, 2022, 6:43pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/3 "2022-02-17T18:43:07Z")
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. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [February 17, 2022, 6:46pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/4 "2022-02-17T18:46:23Z")
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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac29e96ff57eedbf8af15f1c8fbf03dad233d008.png) Saludos! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 17, 2022, 6:47pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/5 "2022-02-17T18:47:56Z")
try to use it in the template column first ---
**Author:** ![Saul\_Delhom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saul_delhom/32/39097_2.png) [@Saul\_Delhom](https://community.glideapps.com/u/Saul_Delhom)\ **Post date:** [February 17, 2022, 6:50pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/6 "2022-02-17T18:50:08Z")
it’s a good thing I realized… thank you! ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [February 17, 2022, 6:55pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/7 "2022-02-17T18:55:56Z")
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 . 🤬 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f464a0dcf4a54a2cf459715367cecda5771c19e7.png) I think @SantiagoPerez can take it and report this annoying issue. Chao ---
**Author:** ![Saul\_Delhom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saul_delhom/32/39097_2.png) [@Saul\_Delhom](https://community.glideapps.com/u/Saul_Delhom)\ **Post date:** [February 17, 2022, 7:13pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/8 "2022-02-17T19:13:46Z")
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? ![Captura de pantalla 2022-02-17 a las 20.09.50](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/612be987d7d3eef84389034312d368bb8c763dac.png) If I type “11/3” it converts to “3 november”, and if I type “3/11” stays in november too… ![Captura de pantalla 2022-02-17 a las 20.10.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44953995524054eb22fb8e01b4d6def6c40980c7.png) 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 😃 ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [February 17, 2022, 7:26pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/9 "2022-02-17T19:26:10Z")
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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4f676f5d1dbfc8514a137d59fa9aa503e7f7aa7f.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 17, 2022, 7:28pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/10 "2022-02-17T19:28:33Z")
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. ---
**Author:** ![kingzy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingzy/32/15690_2.png) [@kingzy](https://community.glideapps.com/u/kingzy)\ **Post date:** [February 17, 2022, 9:51pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/11 "2022-02-17T21:51:27Z")
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! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 17, 2022, 10:13pm UTC](https://community.glideapps.com/t/something-is-wrong-with-date-format-mm-dd-and-dd-mm/38636/12 "2022-02-17T22:13:27Z")
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?