# šŸ†• Format Date Plugin **URL:** \ **Category:** General\ **Created:** [October 21, 2021, 3:30pm UTC](https://community.glideapps.com/t/format-date-plugin/33411 "2021-10-21T15:30:28Z")\ **Posts on this page:** 19\ **Page:** 3
**Author:** ![garrison](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garrison/32/22059_2.png) [@garrison](https://community.glideapps.com/u/garrison)\ **Post date:** [October 22, 2021, 8:04am UTC](https://community.glideapps.com/t/format-date-plugin/33411/41 "2021-10-22T08:04:38Z")
Probably outside the scope of Luxon but whilst on the subject of dates, how can we disable dates in the past from being selected? Useful for booking requests for dates in the future, i.e. today and beyond. ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [October 22, 2021, 8:13am UTC](https://community.glideapps.com/t/format-date-plugin/33411/42 "2021-10-22T08:13:03Z")
Date component has the option to have only future dates: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9d083572864e519868eb45e00a49511a063bccf.png) ---
**Author:** ![garrison](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garrison/32/22059_2.png) [@garrison](https://community.glideapps.com/u/garrison)\ **Post date:** [October 22, 2021, 8:25am UTC](https://community.glideapps.com/t/format-date-plugin/33411/43 "2021-10-22T08:25:48Z")
Thank you, I missed that! Is it a relatively new feature because I didnā€™t see it when I originally built my pro app in May 2020. ---
**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 22, 2021, 8:34am UTC](https://community.glideapps.com/t/format-date-plugin/33411/44 "2021-10-22T08:34:42Z")
It was added like 1-2 months ago. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [October 22, 2021, 11:22am UTC](https://community.glideapps.com/t/format-date-plugin/33411/45 "2021-10-22T11:22:27Z")
> **[Relative Time column ā€¢ Glide](https://www.glideapps.com/plugins/time-ago)** > > Given a date, returns a string with the relative time (e.g. '1 day ago'). Might already be there ā€¦ ---
**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:** [October 22, 2021, 12:03pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/46 "2021-10-22T12:03:09Z")
@david must have went for the late night coffee. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 22, 2021, 12:33pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/47 "2021-10-22T12:33:15Z")
This is my new favoriteā€”thanks @david! It even does future dates! > [@V88](#): > > [Relative Time column | Glide](https://www.glideapps.com/plugins/time-ago) > > Might already be there ā€¦ ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [October 22, 2021, 12:37pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/48 "2021-10-22T12:37:44Z")
Must be a very long ā€œJumboā€ brainy dose American coffee, and not an expressoā€¦ I canā€™t see how technically you can sip your coffee and code at the same timešŸ¤” Hand Free Mind Power? šŸ˜„ ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 22, 2021, 12:39pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/49 "2021-10-22T12:39:47Z")
Might be slightly off? @david ![Screen Shot 2021-10-22 at 8.39.15 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c29039ac0cf4d752ed8320ab16a5f6fbba12795.png) ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [October 22, 2021, 12:45pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/50 "2021-10-22T12:45:47Z")
Is it possible to get one that can pull data (Figures) within Date range? I am not sure if its there or not. I one of my Apps, I have a Sales column with transactions by Date, I would like to be able to pull Revenue/Sales within a specified date range e.g 1 May 2021 - 31 May 2021 something to that effect. I am not sure if i am making sense but i hope someone gets what i mean ---
**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:** [October 22, 2021, 12:48pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/51 "2021-10-22T12:48:08Z")
You donā€™t need fancy fetch columns to do that. Just a bit of date math and if-then-else logic šŸ˜‰ ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [October 22, 2021, 12:52pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/52 "2021-10-22T12:52:25Z")
Please Do Tellā€¦I was actaully trying to avoid having to create a lot of columns but if its not too much to ask, you can give me a brief overview and i can try to do the rest šŸ˜… ---
**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:** [October 22, 2021, 12:56pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/53 "2021-10-22T12:56:06Z")
Well, in the simplest form probably a single if-then-else column would suffice. Something along the lines of: - If transaction date is before start date, then empty - Else if transaction date is after end date, then empty - Else true Then anything with true fits within your date range. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [October 22, 2021, 1:09pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/54 "2021-10-22T13:09:24Z")
I think itā€™s just the granularity ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [October 22, 2021, 3:50pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/55 "2021-10-22T15:50:02Z")
You want a relational SELECT WHEN WHERE CONDITIONS for data filtering/extractions, if I may formulate a broader general feature, Luther? ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [October 22, 2021, 4:01pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/56 "2021-10-22T16:01:56Z")
Iā€™m working on a knowledge base. With long text (from a mobile POV: 3 scrolls max) that need formatting to be decent. Mark.up.down (never know whatā€™s the right word) is really tedious, especially if not everything is rendered as expected. Would be great to use a mark.up.down editor-previewer-converter directly inside/from a column. And not use Google Sheet for multilines rich text. If itā€™s consistent/relevant with the Glide architecture, mindset & strategy? Thks, David šŸŒø ---
**Author:** ![Kyan\_Lynch](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyan_lynch/32/28521_2.png) [@Kyan\_Lynch](https://community.glideapps.com/u/Kyan_Lynch)\ **Post date:** [October 22, 2021, 4:21pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/57 "2021-10-22T16:21:39Z")
Not sure if this is possible, but a plug in that creates a PDF from a template using input data would be awesome. Iā€™m working on making a CV generator tool using webhooks and integromat, and itā€™s just a lot more complicated than Iā€™d like! Awesome job with these, theyā€™ve really opened up new ideas for me with future app features! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 2, 2021, 5:09pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/58 "2021-11-02T17:09:04Z")
> [@david](#): > > I should add an optional `Input Format` argument so you can help it interpret the input date. You now have total control over parsing dates! [https://www.glideapps.com/plugins/parse-date](https://www.glideapps.com/plugins/parse-date) ---
**Author:** ![Damien\_Pugin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/damien_pugin/32/46621_2.png) [@Damien\_Pugin](https://community.glideapps.com/u/Damien_Pugin)\ **Post date:** [August 22, 2022, 10:11am UTC](https://community.glideapps.com/t/format-date-plugin/33411/59 "2022-08-22T10:11:04Z")
How did you do to setup the french translation ? Itā€™s in english only for me. [Previous page](https://community.glideapps.com/t/format-date-plugin/33411.md?page=2)