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 separ…

Here is an example: [CleanShot 2024-02-07 at 21.03.52@2x] 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 Fo…

Need Month Name (text) and Year from Date

Ask for Help

Dilon_Perera February 6, 2024, 10:36am 2

Tried with JS and not sure if there’s a better way!

2 Likes

Topic		Replies	Views
Get month from date as plain text Ask for Help	12	3291	March 22, 2022
MOnth only computed column from date column Ask for Help	4	385	August 27, 2024
How to pull Month text Ask for Help	5	389	January 17, 2024
🗓 Month, Day, and Year Math Functions Ask for Help	47	3714	July 15, 2023
Date math - 3 months from a specific date Ask for Help	9	892	July 20, 2022

Need Month Name (text) and Year from Date

Related topics