MOnth only computed column from date column

[John_Romano]

how do i extract just the month of the date from a computed column?

[Jeff_Hager]

MONTH(Date) in a math column

[Darren_Murphy]

Just to add to Jeff’s reply, if you’re looking for the name of the month, then see below:

New Math functions

Method 1: Use the Format Date column with the MMMM formatting option. Method 2: Add the month names of the year in a single column, one row per month Use a Math column to determine the Month Index number from the date: Month(Date)-1 Use a Single Value column to fetch the month name from your list of months, using N from start where N is the month index. Method 2 requires more effort, but it is more reliable and is guaranteed to work regardless of device/browser/regional date format variati…

[Nyi_Nyi_Soe_Win]

@New Math functions

from your list of months, using N from the start where N is the month index. Method 2 requires more effo

Sorry Can you please explain more I don’t get N mean or method 2 with some demo

[Jeff_Hager]

N is the 'N’umber result from the math formula Month(Date)-1. It ends up being the month number minus one. That result is used with the single value column to tell it which row in the month name table you want.

For example, it’s August, which is the 8th month. 8 - 1 = 7. This tells the Single Value column that you want the 7th row from the 1st row. Add 7 to 1 and you get 8, which is the 8th row, which contains the month name of August.