# 🆕 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:** 20\ **Page:** 1
**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:** [October 21, 2021, 3:30pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/1 "2021-10-21T15:30:28Z")
I’m making a new column each morning with my coffee. This morning I made [Format Date](https://www.glideapps.com/plugins/format-date): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/31eeb992f05e593069c9021f66be9adc891070b1.png) You can read about the formatting options here: [luxon - Immutable date wrapper](https://moment.github.io/luxon/#/formatting?id=table-of-tokens) Please give it a whirl! I am also taking requests for new columns. ---
**Author:** ![Aymeric\_de\_Maussion](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymeric_de_maussion/32/29505_2.png) [@Aymeric\_de\_Maussion](https://community.glideapps.com/u/Aymeric_de_Maussion)\ **Post date:** [October 21, 2021, 3:36pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/2 "2021-10-21T15:36:41Z")
So cool and good to know!! Thanks, is-it difficult to make OCR column ? Maybe with this solution : [Optical character recognition (OCR)  |  TensorFlow Lite](https://www.tensorflow.org/lite/examples/optical_character_recognition/overview) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [October 21, 2021, 3:38pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/3 "2021-10-21T15:38:29Z")
Hola @david How about a column where you input two dates and it gives you an array of the dates in between. Ex: input 1: 10/12/2021 Input 2: 10/20/2021 Result: 10/13/2021, 10/14/2021, 10/15/2021, 10/16/2021, 10/17/2021, 10/18/2021, 10/19/2021 ---
**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:** [October 21, 2021, 3:38pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/4 "2021-10-21T15:38:56Z")
That could be a very big array! ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [October 21, 2021, 3:40pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/5 "2021-10-21T15:40:35Z")
I know. But it could be useful if you are creating a scheduling app that involves days like a hotel or car rental situation. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [October 21, 2021, 3:43pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/6 "2021-10-21T15:43:20Z")
@david iso weeknumber. The one native in glide does non-iso week number ---
**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:** [October 21, 2021, 3:44pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/7 "2021-10-21T15:44:14Z")
> [@Krivo](#): > > iso weeknumber This column does that: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a2485a0d10f2b880108337c652aece6a8b9b560.png) ---
**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 21, 2021, 3:44pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/8 "2021-10-21T15:44:19Z")
> [@david](#): > > I am also taking requests for new columns. Giddy-up! Where should we make these requests? ---
**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:** [October 21, 2021, 3:46pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/9 "2021-10-21T15:46:16Z")
> [@Robert\_Petitto](#): > > Giddy-up! Where should we make these requests? Here, I guess! ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [October 21, 2021, 3:49pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/10 "2021-10-21T15:49:27Z")
What about selected text? If you select a text inside a TEXT BOX and pass it to a plugin to calculate the starting and end position would be nice to create a TEXT FORMAT. ---
**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 21, 2021, 3:49pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/11 "2021-10-21T15:49:37Z")
This is amazing…Now I can grab the offset of date/time! ![Screen Shot 2021-10-21 at 11.49.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/74a1755024c8e954beff83f32ee12839ed7f5ebf.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:** [October 21, 2021, 3:53pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/12 "2021-10-21T15:53:56Z")
@Robert_Petitto So much for all the hard work I put into automatically figuring out the offset. This is much easier. @david this is a lovely addition! ---
**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 21, 2021, 4:02pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/13 "2021-10-21T16:02:52Z")
Can this do units of time, such as unix time or the decimal representation of a date? ---
**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:** [October 21, 2021, 4:04pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/14 "2021-10-21T16:04:15Z")
You can read about the formatting options here: [luxon - Immutable date wrapper](https://moment.github.io/luxon/#/formatting?id=table-of-tokens) ---
**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\ **Post date:** [October 21, 2021, 4:05pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/15 "2021-10-21T16:05:51Z")
@david An address lookup would be amazing! For example, if I search for **Hyatt Regency Boston** , the field would populate the address. Or something to that nature. This is great stuff!! ---
**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 21, 2021, 4:05pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/16 "2021-10-21T16:05:52Z")
Perfect! ---
**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 21, 2021, 4:12pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/17 "2021-10-21T16:12:03Z")
@david My requests: 1. Pretty time (just now, x hours ago, yesterday, x days ago, etc.) 2. % escaped text 3. website validator 4. FontAwesome Icon given shortcode (and let us determine size/manipulations as defined **[here](https://fontawesome.com/v6.0/docs/web/style/styling)**) 5. Suggested Emoji from Keyword (eg. [Emoji Suggestions API | RiteKit](https://ritekit.com/api-demo/emoji-suggestions)) ---
**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:** [October 21, 2021, 4:19pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/18 "2021-10-21T16:19:45Z")
@Robert_Petitto can you say more about escaped text and website validator? ---
**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 21, 2021, 4:20pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/19 "2021-10-21T16:20:12Z")
> [@Robert\_Petitto](#): > > Pretty time I think it’s also called fuzzy dates. I was just thinking about that too. I would like to see a raw math column that lets me plug in a complete formula from a user entered string. Something so I’m not tied to a preset formula in a math column. ---
**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 21, 2021, 4:21pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/20 "2021-10-21T16:21:44Z")
Cool, in French 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c779ef7481fa28ab51c4cf16eb27115452cf0cc.png) But the input Date has to comply/convert to this exact format to work? I tried with a french format JJ/MM/AAAA and an appropriate token like DDD, it does not seem to react. Thks, David 🌸 [Next page](https://community.glideapps.com/t/format-date-plugin/33411.md?page=2)