# Change Date Format **URL:** \ **Category:** Ask for Help\ **Created:** [September 3, 2020, 6:20am UTC](https://community.glideapps.com/t/change-date-format/15193 "2020-09-03T06:20:39Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 3, 2020, 6:20am UTC](https://community.glideapps.com/t/change-date-format/15193/1 "2020-09-03T06:20:39Z")
Hi! How can I remove the end portion of the date format (after the 18) Also, how can I change the order so its Month-Day-Year. Thank you! ![date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dbfd0cceb0f6c6b5f21d8bc5f767744556508335.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:** [September 3, 2020, 6:41am UTC](https://community.glideapps.com/t/change-date-format/15193/2 "2020-09-03T06:41:58Z")
Set the formatting on the date column in the glide data editor. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 3, 2020, 6:59am UTC](https://community.glideapps.com/t/change-date-format/15193/3 "2020-09-03T06:59:31Z")
I looked there, doesn’t give me an option to change. ![date1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e9eab9f4b1906aada5b061b5a6bbe91d60621f1e.png) ---
**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:** [September 3, 2020, 8:54am UTC](https://community.glideapps.com/t/change-date-format/15193/4 "2020-09-03T08:54:41Z")
Where does the “2020-09-18…” thing live in your data? It should be there instead of a blank, or is it noto on your first row? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 3, 2020, 10:04am UTC](https://community.glideapps.com/t/change-date-format/15193/5 "2020-09-03T10:04:32Z")
Your “Start Date” column needs a date in the first row for Glide to recognize it as a date field. Then you can set the formatting as needed. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 3, 2020, 11:40am UTC](https://community.glideapps.com/t/change-date-format/15193/6 "2020-09-03T11:40:11Z")
Oh! that screenshot was afterwards 🙂 I’m testing on a live app so had to remove my test data right after snapping it, but yes its in the first row. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 3, 2020, 11:46am UTC](https://community.glideapps.com/t/change-date-format/15193/7 "2020-09-03T11:46:19Z")
Ahh…thanks! I overlooked the date/time as an option. Do you know what data the short and medium grabs or looks like? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 3, 2020, 12:18pm UTC](https://community.glideapps.com/t/change-date-format/15193/8 "2020-09-03T12:18:08Z")
I believe short is MM/DD/YYYY and medium is MMMM DD, YYYY. Order may vary depending on location (which I wish wouldn’t be the case, but likely needs to be this way for global users). ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [September 3, 2020, 3:19pm UTC](https://community.glideapps.com/t/change-date-format/15193/9 "2020-09-03T15:19:58Z")
Ok! thanks Ill either wait for a real submission or test it out in the wee hours of the morning 😄 ---
**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\ **Post date:** [October 13, 2020, 11:09pm UTC](https://community.glideapps.com/t/change-date-format/15193/10 "2020-10-13T23:09:38Z")
If I wanted the date to display in the app as MM-DD-YYYY, how could I do that? I set it the column in Sheets to display as that, and it does, but it won’t transfer to Glide. Glide displays the date as MM/DD/YYYY. @kyleheney @ThinhDinh ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [October 13, 2020, 11:11pm UTC](https://community.glideapps.com/t/change-date-format/15193/11 "2020-10-13T23:11:28Z")
How are you displaying it like that in Sheets? If you use a TEXT formula, Glide may not recognize it as a date and may format it the way you want. That would, however, mean it’s not going to be a date in Glide for filtering/visibility purposes. ---
**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:** [October 13, 2020, 11:47pm UTC](https://community.glideapps.com/t/change-date-format/15193/12 "2020-10-13T23:47:39Z")
Probably if he changes the type in the data editor to text, it will honour the format. Just my guess. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [October 14, 2020, 12:06am UTC](https://community.glideapps.com/t/change-date-format/15193/13 "2020-10-14T00:06:50Z")
Ah yes forgot you can change the column type in the editor now. Biggest issue is he’ll lose date-type filtering. Alternative would be to do this through the new month day year math columns to have the date as a regular date, then use those columns to build a template in whatever format you want. ---
**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:** [October 14, 2020, 12:15am UTC](https://community.glideapps.com/t/change-date-format/15193/14 "2020-10-14T00:15:58Z")
Yeah I think your approach is better to do both things! ---
**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\ **Post date:** [October 14, 2020, 2:05am UTC](https://community.glideapps.com/t/change-date-format/15193/15 "2020-10-14T02:05:09Z")
So, the solution is to have that column containing the birth date be a Math column, or 3 separate Math columns, one for month, one for day, and one for year? Sorry, I’m confused… ---
**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\ **Post date:** [October 14, 2020, 2:06am UTC](https://community.glideapps.com/t/change-date-format/15193/16 "2020-10-14T02:06:30Z")
Forgot to add that I am using the Glide’s Date Picker when adding/editing student’s info. Does that have any effect on Glide’s ability to display the date as MM-DD-YYYY, and not as it currently is, which is MM/DD/YYYY. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [October 14, 2020, 10:06am UTC](https://community.glideapps.com/t/change-date-format/15193/17 "2020-10-14T10:06:20Z")
I would gather the dates using the date picker and have them formatted however Glide can do them. Next I’d add a math column to extract the month number and do the same with the day and year too. Then I’d create a template column to put those math columns together however I want. This new template column can be used to display the dates in the app but the original date column is what is capturing the actual dates entered by users. ---
**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\ **Post date:** [October 14, 2020, 1:38pm UTC](https://community.glideapps.com/t/change-date-format/15193/18 "2020-10-14T13:38:58Z")
Ok, I just decided to go with the regular Text column. Seems to work for what I’m needing, and it inherits Sheets date settings that I’ve assigned to that column. Thanks for the help…as always. ---
**Author:** ![Zapstuff](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zapstuff/32/37592_2.png) [@Zapstuff](https://community.glideapps.com/u/Zapstuff)\ **Post date:** [February 22, 2021, 4:31pm UTC](https://community.glideapps.com/t/change-date-format/15193/19 "2021-02-22T16:31:37Z")
Hi, I’m working on a similar problem–I’m trying to convert Glide time/date format into Unix crontab format (min/hour/day/month). Could you elaborate on your suggestion to use math columns to extract the month, day (and hour & min) numbers from a date? Thanks so much! ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [February 22, 2021, 4:44pm UTC](https://community.glideapps.com/t/change-date-format/15193/20 "2021-02-22T16:44:26Z")
Do you want it all in one line in that order (min/hour/day/month)? [Next page](https://community.glideapps.com/t/change-date-format/15193.md?page=2)