Auto-generated Create Date - remove time

Wayne Pacholl

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?

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.