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 | |
27 | |
24 | |
22 | |
13 |