Truncating time off of Date Created field for Report

Trying to create a report of contacts added last 7 days, grouped by day. Our Date Created field has a time stamp as well, so we get individual returns per time stamp, unless there was a dump of contacts at the same time. Is there either a customfunction or GUI way to just use the date? Or will the field have to be altered in CRM first?

Use custom SQL function to format your date time field to date field
DATE_FORMAT({t}.{f}, ā€˜%Y-%m-%dā€™)

1 Like