[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

Translating dates to Months

Good morning,

I have a report that takes date from Jan 1 to Dec 31 of the year.  From there I would like the data to be represented in the report based on month.

For example:

Jan                         Feb                        March                         April....
summary details    summary details   summary details        Summary details

Can you assist in categorizing the date/time field into months?  Any help would be appreciated!

thank you -
cs
0
rporter45
Asked:
rporter45
  • 2
1 Solution
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Insert, CrossTab
Drag your date field to the column area of the CrossTab
In Group Options for the CrossTab column field, select 'for each Month'
0
 
rporter45Author Commented:
Thanks for the quick response, I will try this later today and get back to you,

cs
0
 
mlmccCommented:
SOunds like the right idea.  If you need help setting it up just ask more questions

mlmcc
0
 
rporter45Author Commented:
Sorry for the delay - worked perfectly!

Thank you - cs
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now