Does the DATEONLY function only work on the created date field?
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.
Answers
-
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?
-
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?
-
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)))
-
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?
-
Hi @Keahna,
Using the formula that Paul provided above this should only display the date that you require.
John
-
@Keahna All you should need to change with my formula is [Column Name] to match the column name you are using in your sheet.
Help Article Resources
Categories
Check out the Formula Handbook template!