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 |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |