I have a Timestamp column in my data, and want to include just the date in my report. I donโt want to add a column for data that is only used in one place, if I can get it from somewhere else (trying to keep my tables as small as possible.)
I tried using <<Left([Timestamp],Find([Timestamp],โ โ))>> but that didnโt work. Is there a way to extract the date from the Timestamp in a report (Google Docs)?
You can read it like <<DATE([Timestamp])>>
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |