What's new in Customer Journeys?

Connect and learn more!
Group by month/Year only using a date field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Group by month/Year only using a date field

Accepted answer
81
Views
2
Comments
edited Dec 14, 2017 2:17PM in Reporting & Analytics for Sales 2 comments

Summary

How can I group by month/year only using a date field from Sales Cloud?

Content

I have a report which includes a date field from Sales Cloud Opportunity object. I would like to group this report by the month/year element only.

I tried to add a month only field in Sales Cloud, which could then be brought through to the report and used for grouping, but the only date fields available are the full date format.

Is there any way in reporting that I can group by the month/year element only on a report?

I would appreciate any help or suggestions, thank you.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!