# Get month from date as plain text **URL:** \ **Category:** Ask for Help\ **Created:** [March 22, 2022, 6:14am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936 "2022-03-22T06:14:47Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![makerslade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makerslade/32/16220_2.png) [@makerslade](https://community.glideapps.com/u/makerslade)\ **Post date:** [March 22, 2022, 6:14am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/1 "2022-03-22T06:14:47Z")
I’d like to add another column and extract the month from the date captured. I’ve done this in number format but I want to have it in text format as well. For example, if a record was captured with the date **Friday, June 10, 2022** the month number column will say **6** and the month text column will say **June**. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96359085c9294a111f153ff219a732c0f02ab69e.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2022, 6:28am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/2 "2022-03-22T06:28:09Z")
add a column that has all month’s names, a column with corresponding month numbers, and a relation column to connect month number with your math column, and the last column… a lookup column to for this relation to show text month name… I see that you are doing business operating hours… it is a very complex task… you can find inspiration in my app: > **[Business hours & QR DEMO](https://business-hours-demo.glideapp.io/)** > > adjust business operating hours, blockout dates, check if business is open now, QR vCard for easy adding to contacts. ---
**Author:** ![makerslade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makerslade/32/16220_2.png) [@makerslade](https://community.glideapps.com/u/makerslade)\ **Post date:** [March 22, 2022, 6:39am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/3 "2022-03-22T06:39:42Z")
Hi Uzo, thanks for your comment. It’s actually not complicated at all. I’ve already finished the app, it’s used to capture odometer readings for delivery drivers. Here are the two sheets that capture data and sum them by month: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/31912ce2c1ceb5298d83985d3dda4e98302f42b4.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a34d2c065fd33ed77933011634f7ee270bef143.png) I’m just wanting to add one last thing and that is getting the month text out of the date captured so that I can group by month in my list of captures displayed to the user. At the moment I am using the month number as a placeholder: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6deb0ec5d91b679b340fddb57c2420c1c8fc1d1c.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2022, 6:42am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/4 "2022-03-22T06:42:14Z")
i did grouping by months in my other app… check it out… > **[Personal Time Card DEMO](https://time-card-demo.glideapp.io/)** > > Track your working hours, sort by week, month, or year. Export as PDF files ![Screen Shot 2022-03-22 at 2.41.16 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/8269fcdb730cb8beefe349251dd8aa1a124b9f25.jpeg) ---
**Author:** ![makerslade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makerslade/32/16220_2.png) [@makerslade](https://community.glideapps.com/u/makerslade)\ **Post date:** [March 22, 2022, 6:49am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/5 "2022-03-22T06:49:40Z")
I already have the month number extracted from the date: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b67b9094a5a71b43cabf7fa5d28e9f75087e130f.png) I’m sure there’s a simple way to extract the month in text format. I’ll figure it out, thanks. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2022, 6:52am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/6 "2022-03-22T06:52:21Z")
you have month’s names and assigned numbers, now just relate these numbers to your math column extracting month numbers… do lookup for month name… that’s all… you can change math precision so it doesn’t look weird 😉 ---
**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:** [March 22, 2022, 7:02am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/7 "2022-03-22T07:02:50Z")
> [@Uzo](#): > > add a column that has all month’s names, a column with corresponding month numbers, and a relation column to connect month number with your math column, and the last column… a lookup column to for this relation to show text month name… You can skip the relation and the lookup. Just adjust the math column so that it returns the month index number, eg `Month(date)-1` And then use a Single Value to get the month name, selecting the “month index” from the start. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2022, 7:06am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/8 "2022-03-22T07:06:23Z")
single value? he has to assign deferent names to all rows… ---
**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:** [March 22, 2022, 7:50am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/9 "2022-03-22T07:50:05Z")
Exactly. ![Screen Shot 2022-03-22 at 3.49.07 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b41be3f58bb776825bbd31fccc6797817455eea5.png) ![Screen Shot 2022-03-22 at 3.48.56 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/fac2fb469a030303dc3f9f4b6e995fd9ce2d4527.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2022, 7:53am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/10 "2022-03-22T07:53:58Z")
this is a different kind of magic 😉 ---
**Author:** ![makerslade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makerslade/32/16220_2.png) [@makerslade](https://community.glideapps.com/u/makerslade)\ **Post date:** [March 22, 2022, 8:44am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/11 "2022-03-22T08:44:25Z")
Thanks, Darren. I’ve adjusted as you mentioned but am having trouble using the month name column to group records in my list. Doesn’t display any data. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b8f616219c098d40d2a539cc483373ddd8c0fb7.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4dfdf8a683c0fdf13e8433acc7f25b71eef6aae2.png) ---
**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:** [March 22, 2022, 9:09am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/12 "2022-03-22T09:09:51Z")
What you have there looks okay, but I’m aware that there have been several date-related issues with Glide recently. Here is something to try: - Remove the Grouping on your Inline List - Set the Inline List so that it displays the Month Name as the Details Examine what you see, and check if it looks correct. ie. correct month name assigned to each record. Edit: Actually, what are you using as the source of that Inline List? You have no filter applied, so even if the grouping isn’t working, you should still see records. The only other thing that might trip things up is Row Owners. ---
**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:** [March 22, 2022, 11:42am UTC](https://community.glideapps.com/t/get-month-from-date-as-plain-text/39936/13 "2022-03-22T11:42:44Z")
Might want to double check your numbering if you still have this. ![Screenshot_20220322-064201-826](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c987f0c514866b78c4b8cf91d72fe342811f457b.jpeg)