Welcome!

Auto-generated Create Date - remove time

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?

Find more posts tagged with

Comments

Atus Bartal

Wayne,

use DATEONLY() function.

Check out in this Help article:

DATEONLY(): Extracts the date portion of a date/time value.

Example: =DATEONLY([Due Date]5)
Result: 03/01/14

NOTE: Currently only system columns and start/end date columns in dependency-enabled project sheets have a time component.

Wayne Pacholl

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?

Dave D

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.

Atus Bartal

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

LouSnz

Is it possible to get the time only portion of the created column using a formula?

Atus Bartal

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.