I am familiar with how to truncate date and time fields in SQL and crystal reports, but it seems like this is not possible in ServiceNow Reporting unless you have admin access and can write scripts?
The end result is I need to make pivot and multi level pivot tables using date and time fields like created, opened, resolved, closed, etc. I only need to see columns of data grouped by day, week, month. I do not need 100,000 columns for every change of the minute for each incident, interaction, or data point I am pulling into the pivot tables.
Is this possible? It seems like such a basic function in 2024
