# Thank you for date format plugin **URL:** \ **Category:** Project Showcase\ **Created:** [July 7, 2022, 3:06am UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020 "2022-07-07T03:06:22Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![fluittsolutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fluittsolutions/32/30155_2.png) [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)\ **Post date:** [July 7, 2022, 3:06am UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020/1 "2022-07-07T03:06:22Z")
Glide Team, Thank you for the date format plugin! I had created my own using Google Sheet formulas for multiple columns I needed including day of week only, month only, year only, and month/year combined. It was doing what I needed it to do in the app, but I had to drag those formulas down the columns in my Google Sheets to have the fields populate in my Glide App in new rows. I have now replaced them all with new plugins and life just got a little easier! Sincerely, Mona ---
**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:** [July 7, 2022, 3:17am UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020/2 "2022-07-07T03:17:34Z")
Even without the Date Format plugin, most of those things you were going in your Google Sheet would have been relatively easy to achieve in Glide with a combination of Date Math and Template columns. It’s almost always a good idea to get rid of spreadsheet formulas and replace them with Glide computed columns. If you have others you’d like to get rid of and are not sure how to do it, feel free to ask here. Lots of people willing to help 🙂 ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [July 7, 2022, 4:17pm UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020/3 "2022-07-07T16:17:07Z")
Hi @Darren_Murphy if i want to set Monday in the first Sunday of the following month is it possible to implement in Glide? If only I had 5 dates with different months. Here’s an example: I want to get Monday on the first Sunday of this month, then the following month must be Monday on the first Sunday too 3-07-2022 7-08-2022 4-09-2022 2-10-2022 6-11-2022 ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [July 7, 2022, 4:34pm UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020/4 "2022-07-07T16:34:07Z")
> [@Finding date in a Range](https://community.glideapps.com/t/finding-date-in-a-range/42740/2): > > Gotta tell you that this is not reliable and might break with iOS. Nowadays I stay away from this, it caused me too much trouble in the past. Glide’s underlying date/time format combined with Luxon was not friendly for Safari, and it almost always returned “invalid” for me. I would just convert it to a numerical column, I believe Bob had the same method in his video. I usually do YYYYMMDD so my formula is: YEAR(D)\*10000 + MONTH(D) \* 100 + DAY(D) With D being the timestamp in question. I used the new luxon format for dates (Plugin) and liked it but was kinda warned away from it by Thinh and Bob especially since I develop occasionally in Safari (but mostly chrome). Glad it is working - any issues so far? ---
**Author:** ![fluittsolutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fluittsolutions/32/30155_2.png) [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)\ **Post date:** [July 7, 2022, 10:23pm UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020/5 "2022-07-07T22:23:56Z")
Fortunately, I not doing any heavy-lifting calculations or ranges…I just need formatting. I want to be able to see that 7/7/2022 is “Thursday.” That’s all I need. I’m allowing users to filter on “show me farmers markets on Sundays.” ---
**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:** [July 8, 2022, 12:49am UTC](https://community.glideapps.com/t/thank-you-for-date-format-plugin/44020/6 "2022-07-08T00:49:45Z")
If you only need that, maybe you can just use a weekday formula within a math column. It will return 1 for Sunday, 2 for Monday up to 7 for Saturday. Then you can just map the number back to the text for the day, so users can filter by the text.