Possible to format system date columns?

Sing C

I have a sheet that captures "Created" system date for when an associated form is submitted. I would like to display the date portion of the field only (i.e. not interested in showing the time) in a report but not sure how to.

Any help appreciated!

Paul Newcome

There are a couple of ways.

You can create a date column and enter

=DATEONLY(Created@row)

Or you can remove the system generated column entirely and use a Record A Date automation set to trigger whenever a new row is added.

Paul Newcome

There are a couple of ways.

You can create a date column and enter

=DATEONLY(Created@row)

Or you can remove the system generated column entirely and use a Record A Date automation set to trigger whenever a new row is added.