Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I'd like to filter on things created on a certain date, I don't need time. Anyway to remove time from the auto-generated field?
Wayne,
use DATEONLY() function.
Check out in this Help article:
DATEONLY(): Extracts the date portion of a date/time value.
Thanks Atus. I see how I can use that on an existing list of data. I don't suppose I can use this for the auto-generated field so it defaults that formula to any newly created records?
The created date/modified date columns will always show time but you can run calculations off of them and run filters/reports based on the date without removing the time. Just use it the way you would use a Date column.
Thanks, Dave, that's right.
Wayne, for your question: yes, if the formula is in the last row, and you write in a new one, the formula will "go" with it, so the column in the new row will be auto-populated (first with "MISSING OR INVALID PARAMETERS", but once you save your data, there will be dates).
I saved this sheet before typing "five" (ignore the 2nd column and the strange date format):
Atus
Is it possible to get the time only portion of the created column using a formula?
Sorry, I don't know. There's no formula for it like DATEONLY().
If you try with =Modified53 - DATEONLY(Modified53), it gives you zero, so you can't even calculate with it.
