Skip to main content
added 51 characters in body; edited tags
Source Link

Trying to get the text value of the month. Created a calculated column with a return type of 'Date', but can get the result only for 'Created' field.

This works:This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..

 

update: Thank You for the response, Mohammed!

Strange that You have more columns in Your multiple lookup("Insert column" on right side). I don't have 'Start/End Date' columns there:

enter image description here

enter image description here

Maybe some feature needed..

enter image description here

I have publishing enabled on this site-collection.

Trying to get text value of month. Created calculated column with return type of 'Date', but can get result only for 'Created' field.

This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..

update: Thank You for response Mohammed!

Strange that You have more columns in Your multiple lookup("Insert column" on right side). I don't have 'Start/End Date' columns there:

enter image description here

enter image description here

Maybe some feature needed..

enter image description here

I have publishing enabled on this site-collection.

Trying to get the text value of the month. Created a calculated column with a return type of 'Date', but can get the result only for 'Created' field.

This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..

 

update: Thank You for the response, Mohammed!

Strange that You have more columns in Your multiple lookup("Insert column" on right side). I don't have 'Start/End Date' columns there:

enter image description here

enter image description here

Maybe some feature needed..

enter image description here

I have publishing enabled on this site-collection.

added 535 characters in body
Source Link
Gennady G
  • 1.6k
  • 3
  • 22
  • 38

Trying to get text value of month. Created calculated column with return type of 'Date', but can get result only for 'Created' field.

This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..

update: Thank You for response Mohammed!

Strange that You have more columns in Your multiple lookup("Insert column" on right side). I don't have 'Start/End Date' columns there:

enter image description here

enter image description here

Maybe some feature needed..

enter image description here

I have publishing enabled on this site-collection.

Trying to get text value of month. Created calculated column with return type of 'Date', but can get result only for 'Created' field.

This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..

Trying to get text value of month. Created calculated column with return type of 'Date', but can get result only for 'Created' field.

This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..

update: Thank You for response Mohammed!

Strange that You have more columns in Your multiple lookup("Insert column" on right side). I don't have 'Start/End Date' columns there:

enter image description here

enter image description here

Maybe some feature needed..

enter image description here

I have publishing enabled on this site-collection.

Source Link
Gennady G
  • 1.6k
  • 3
  • 22
  • 38

Calulated month from "Start Time", does it work in Your Online?

Trying to get text value of month. Created calculated column with return type of 'Date', but can get result only for 'Created' field.

This works:

=TEXT((MONTH(Created)),"MMMM")

Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([EventDate])),"MMMM")
=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")
=MONTH(([EventDate]),"MMMM")

How?..