Does the DATEONLY function only work on the created date field?

Keahna

I have an export out of another program that I am importing to smartsheet that is pulling a date and time column. I need to pull just the date out of that column but keep getting the "INVALID DATA TYPE" error.

Paul Newcome

A date/time stamp from an import is going to be stored as a text string. That is why the DATEONLY function is not working. You would need to write a formula using the DATE function to strip out each piece of the date and populate it as a date value that way. What is the format of your date/time stamp?

Keahna

01/07/24 00:00:000

This is how the import is formatting the text string. How would I pull the information out with the DATE function?

Paul Newcome

Assuming your current format is mm/dd/yy, it would look something like this:

=DATE(VALUE("20" + MID([Column Name]@row, 7, 2)), VALUE(LEFT([Column Name]@row, 2)), VALUE(MID([Column Name]@row, 4, 2)))

Keahna

My current format is a text string of mm/dd/yy hh:mm:sss ; I need to pull just the date part out of it. Can I write the DATE formula the same way and just ignore the time portion to pull just the date out?

John_Foster

Hi @Keahna,

Using the formula that Paul provided above this should only display the date that you require.

John

Paul Newcome

@Keahna All you should need to change with my formula is [Column Name] to match the column name you are using in your sheet.