# Incorrect Date Format **URL:** \ **Category:** Ask for Help\ **Created:** [December 1, 2021, 9:13am UTC](https://community.glideapps.com/t/incorrect-date-format/35338 "2021-12-01T09:13:44Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Dale\_Nelson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dale_nelson/32/18650_2.png) [@Dale\_Nelson](https://community.glideapps.com/u/Dale_Nelson)\ **Post date:** [December 1, 2021, 9:13am UTC](https://community.glideapps.com/t/incorrect-date-format/35338/1 "2021-12-01T09:13:44Z")
Hey I have an issue with date in the Glide interpretation of the sheet. I am using a text function to format the dates to DD-MM-YYYY but it is still chopping and changing from DD-MM-YYYY to MM-DD-YYYY in Glide from column to column despite all of the columns being formated. Does anyone know how to resolve this? ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [December 1, 2021, 9:19am UTC](https://community.glideapps.com/t/incorrect-date-format/35338/2 "2021-12-01T09:19:20Z")
Hi. Not sure Glide can recognize date formatting if it is the text-type format. Try to format dates in Glide using the FormatDate column. > **[Format Date column • Glide](https://www.glideapps.com/plugins/format-date)** > > Powerful date & time formatting with luxon. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 1, 2021, 9:20am UTC](https://community.glideapps.com/t/incorrect-date-format/35338/3 "2021-12-01T09:20:00Z")
When you say all the columns have been formatted, are you referring to the columns in the Glide Data Editor? Regardless of how your spreadsheet columns are formatted, you will need to ensure the same columns are also formatted as [date/time](https://docs.glideapps.com/all/reference/data-editor/basic-columns/date-time-formats) type in Glide. Note that although Glide might initially recognise the columns as date/time, it doesn’t always get the format right. It’s always a good idea to edit the column and make sure. For specific formatting options, there is a [Format Date](https://www.glideapps.com/plugins/format-date) plugin. However, take care with that as I’m aware that it doesn’t always play well with non-US date format/locale. ---
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [December 1, 2021, 9:06pm UTC](https://community.glideapps.com/t/incorrect-date-format/35338/4 "2021-12-01T21:06:08Z")
Using the format date plugin to get DD-MM-YYYY you have to type dd-MM-y as the format. ---
**Author:** ![Dale\_Nelson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dale_nelson/32/18650_2.png) [@Dale\_Nelson](https://community.glideapps.com/u/Dale_Nelson)\ **Post date:** [December 1, 2021, 11:23pm UTC](https://community.glideapps.com/t/incorrect-date-format/35338/5 "2021-12-01T23:23:18Z")
In the glide editor the format of the columns is set to date In the spreadsheet dates were coming up as numbers like 44567.1 So I used a text function to format it to a DD-MM-YYYY date ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 1, 2021, 11:31pm UTC](https://community.glideapps.com/t/incorrect-date-format/35338/6 "2021-12-01T23:31:13Z")
> [@Dale\_Nelson](#): > > In the spreadsheet dates were coming up as numbers like 44567.1 You can format that column’s display to date instead of having to use an extra column with a TEXT formula. > **[How to change date format in Google Sheets and convert date to number and text](https://www.ablebits.com/office-addins-blog/google-sheets-change-date-format/)** > > Learn how Google Sheets formats dates and how you can change the date format, create custom formatting and convert dates to numbers and text ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 5, 2021, 3:36am UTC](https://community.glideapps.com/t/incorrect-date-format/35338/7 "2021-12-05T03:36:25Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.