How to remove the time stamps where I need the incidents count in a day

[Vivekavardhan R]

Hi, I am facing issue here where i have created a pivot table where in the column I have selected "Created" and in the rows "state". But the report is showing like this in the image. Can we remove this time stamps and make it a date?

Please help me with this

[RaghavSh]

@Vivekavardhan R Created is an OOB field which contains date time, you need to find a column on incident table which only shows created date and selected that column in your pivot report.

I believe there is no such column there on incident tableand removing timestamp for this report doest seems to be a feasible option.

Workaround:

 Create a date type field on incident table, which populated the created date on incident through before insert BR( for existing incidents fix script need to be written) . Add this field to your pivot report.

Please mark the answer correct/helpful accordingly.

[Vivekavardhan R]

I created a custom field called "Created Date" and added a calculated script using a dictionary, along with a business rule. However, when I try to generate a pivot table, the column appears empty. I also attempted to convert the value to a string, but that didn’t resolve the issue.

[Ankur Bawiskar]

@Vivekavardhan R 

I don't think you can hide that timestamp.

If my response helped please mark it correct and close the thread so that it benefits future readers.