Report grouping by system generated date?

Chris Armstrong

I'd like to create a report that groups entries by created date, without the timestamp. The entries come from a form, and adding a system generated 'created date' is more efficient. However the grouping function ends up splitting every entry separately because of the timestamps being different.

Is there a way to group by just the created date, and not the time? Or is there a way to remove the time from that column?

Paul Newcome

You could create an additional hidden date type column on your source sheet and use

=DATEONLY([Created (date)]@row)

Then include this column in your report (it can also be hidden in the report) and sort on that.

Paul Newcome

You could create an additional hidden date type column on your source sheet and use

=DATEONLY([Created (date)]@row)

Then include this column in your report (it can also be hidden in the report) and sort on that.

Chris Armstrong

Awesome, thank you!

Paul Newcome

Happy to help. 👍️

Valerie_WPA

Not working for me?

Help please.

Andrée Starå

Hi @Valerie_WPA

I hope you're well and safe!

Try something like this.

=DATEONLY([Created date]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Valerie_WPA You need to use the column name that is in your sheet:

=DATEONLY(Created@row)