# Need Month Name (text) and Year from Date **URL:** \ **Category:** Ask for Help\ **Created:** [February 6, 2024, 10:18am UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550 "2024-02-06T10:18:37Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 6, 2024, 10:18am UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/1 "2024-02-06T10:18:37Z")
I have column which has date in this format “4 January 2024 at 12:47” I need the Value of Month (Text) , Year in a column with name “Month” meaning I should be able to extract Month name and Year into column “Month” In the above example it should read January, 2024. I know how to extract it separately in two different columns. Is there any simpler way / math formula to compute and put value in same cell? Thank you guys in Advance, Regards, Dilip ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [February 6, 2024, 10:36am UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/2 "2024-02-06T10:36:04Z")
Tried with JS and not sure if there’s a better way! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ffe954d83c071bcd393d7977c15f289662354afa.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4c9c31b9712256803f4a79b4d048987c757cd9ef.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/4245079f27aa428c28b0bab195615d180cf30a7f.png) ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 6, 2024, 10:56am UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/3 "2024-02-06T10:56:13Z")
thank you Dilon 🙂 ---
**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:** [February 6, 2024, 11:03am UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/4 "2024-02-06T11:03:49Z")
Please check if this works on iOS/MacOS. I have used Date functions on Safari before and it did fail a few times. ---
**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:** [February 6, 2024, 11:53am UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/5 "2024-02-06T11:53:41Z")
Yeah, I agree with @ThinhDinh. JavaScript and/or the Format Date column both work perfectly fine _most_ of the time. But under some circumstances both can fail on Safari. And when they do, it can be a PITA to try and figure out what went wrong. I always use Math columns for this sort of stuff. `Year(Date)` to get the Year, then `Month(Date)-1` to get the Month Index, followed by a Single Value to get the Month Name. It’s a bit more work, but I’ve never seen this method fail. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 7, 2024, 12:49pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/6 "2024-02-07T12:49:37Z")
Hi Darren, thank you for the reply. then how would you combine them? I need it like January, 2024 Regards, Dilip ---
**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:** [February 7, 2024, 12:51pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/7 "2024-02-07T12:51:46Z")
With a template column. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 7, 2024, 12:56pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/8 "2024-02-07T12:56:02Z")
> [@Darren\_Murphy](#): > > I always use Math columns for this sort of stuff. `Year(Date)` to get the Year, then `Month(Date)-1` to get the Month Index, followed by a Single Value to get the Month Name. It’s a bit more work, but I’ve never seen this method fail. You do this operation in two different columns, then template both columns to get output? I am little confused how would it work? Regards, Dilip ---
**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:** [February 7, 2024, 1:07pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/9 "2024-02-07T13:07:04Z")
Here is an example: ![CleanShot 2024-02-07 at 21.03.52@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/abc040908bff07ea6689bdacb899aed09c3870e9.jpeg) - Month: Obvious. (Usually I would have this in a separate Lookup table) - Date: Obvious - Year: Math column - `Year(Date)` - MonthIndex: Math column - `Month(Date) - 1` - MonthName: Single Value column. X from Start of Month, where X is MonthIndex - Formatted: Template column, joining MonthName & Year ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 7, 2024, 1:10pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/10 "2024-02-07T13:10:26Z")
can you show me how your Formatted column (template) values look? I mean config regards, Dilip ---
**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:** [February 7, 2024, 1:15pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/11 "2024-02-07T13:15:05Z")
![CleanShot 2024-02-07 at 21.14.26@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a63297f4017169913b23ab206a448029095d612.png) ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [February 7, 2024, 1:16pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/12 "2024-02-07T13:16:41Z")
I just saw Darren’s and Thinh’s replies and I believe what Darren suggest is like this! : [20240207184131.mp4 - Google Drive](https://drive.google.com/file/d/1NEDsNqBSyLaRzPrPskz8o1lZ8oW61qm6/view?usp=sharing) ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 7, 2024, 1:21pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/13 "2024-02-07T13:21:15Z")
Thank you Darren 🙂 ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 7, 2024, 1:21pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/14 "2024-02-07T13:21:27Z")
Thank you Dilon 🙂 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 14, 2024, 1:22pm UTC](https://community.glideapps.com/t/need-month-name-text-and-year-from-date/70550/15 "2024-02-14T13:22:17Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.