I want to derive the month of a date field called MeetingDate__c. Purpose of this is to display all Meeting Records grouped by the derived month. I have created a formula field to derive the month from MeetingDate field but it doesnt save:-
Error message display is :-
Error: Formula result is data type (Number), incompatible with expected data type (Date).
Also is there a way that I can show the name of the month instead the number of the month? Ex: If derived month is 05 then display May ?