how to change the date in a pivot table to Month, instead of yy/mm/dd hh:mm:ss

[Teresa Core]

I am new to the reporting side of ServiceNow,  and I have many reports that require specific data that I may need to populate.  one report for starters is showing the wrong date.  I need to group items by date and and turn the bottom field from Minutes to hours.  I am getting the information below and I am not sure where to go to get calculated or custom fields on a report:

[Jaspal Singh · Accepted solution]

Hi Teresa,

Since you are using OOB field Actual Start (datetime) you cannot directly get the month from it. If required you will have to do a Trend by Created & then look for month.

Else you need to create a separate/custom month field altogether & then populate value of month by spliting the value from Actual Start date.

Better, create a report of type Trend or Column & then you can select Month but yes that would mean that you will not have pivot reporting obviously.