Need to remove timestamp from date field

Hayley T.

Hi community,

I am trying to remove the timestamp from a date field that feeds from a data shuttle. I have tried to use the DATEONLY formula, but I am getting an error message of: INVALID DATA TYPE. Within the new column I'm trying to build, I tried both the column type of both date and text/number, but I still can't get it to work. Does anyone have an ideas of how to troubleshoot?

Screenshot 2025-04-25 111007.png

Screenshot 2025-04-25 111042.png

Darren Mullen

@Hayley T. Screenshots are helpful. I see you're storing date time in a normal date column. Smartsheet date columns don't support or recognize values as datetime. The ONLY columns in Smartsheet that utilize datetime are the Created and Modified system columns.

So, the DATEONLY() function will only work on those columns, not a normal date column.

Hayley T.

Thank you, Darren for the quick reply! Is there a different formula we can use to remove the time stamp?

prime_nathaniel

@Hayley T. / @Darren Mullen if it was imported via shuttle its probably in text/number format. Ideally, you can export from source as date. If not you can trim datetime strings to date based on the space character. WORST WORST case scenario you can parse full text into year, value(month), value(day). And convert it back into a date object.