How can i get month number from a month. Please see description

[vibin m]

Hi All,

How can i get month number from a month.

 

I have a date in the format 11/20/2016, i want to get the month number extracted ie 11 and store in a new colum.

 

Thank you,

Vibin.

[Aditya Singh 3]

Create a calculated column as Month([Date]) and change formatting to "Genaral", you will get month value as 1 -12.

[NISHANTH JAIN]

Hello Vibin,

You cantry below logic:

Month([Date])