# Date format locale struggle: sheet vs app **URL:** \ **Category:** Ask for Help\ **Created:** [March 9, 2021, 4:04pm UTC](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007 "2021-03-09T16:04:33Z")\ **Posts on this page:** 1\ **Showing post:** 29
**Author:** ![avanavana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/avanavana/32/15637_2.png) [@avanavana](https://community.glideapps.com/u/avanavana)\ **Post date:** [February 6, 2022, 5:15pm UTC](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007/29 "2022-02-06T17:15:32Z")
A while ago I posted about these issues. I actually resorted to writing apps script to format the dates automatically for me: _(the below links to my earlier post, with annotated apps script)_ > [@Hello, and, On Extending Glide with Google Apps Script](https://community.glideapps.com/t/hello-and-on-extending-glide-with-google-apps-script/17751/6): > > Have to make an update to this thread: It’s known that the event picker widget, while providing an undeniably superior UX compared to, say, two date/time pickers (event picker has smaller chance for mistakes in user input, users can see context of other events when inputting data, one less form field, provides ‘confirmation’ or ‘preview’ of correct input, etc), is still quite buggy. Glide have assured me that these bugs are to be fixed in an update that will drop next week. The major bug that… --- _[View the full topic](https://community.glideapps.com/t/date-format-locale-struggle-sheet-vs-app/24007)._