Can you convert Date to Text in DOMO?

arzconci

Trying to find online but could not.

Main purpose is that when the csv attachment in schedule reports get sent, I want the report to have no "T" stamp.

Current: 2023-11-27T00:00:00

Change to: 2023-11-27 00:00:00

If you guys have other alternatives, please let me know. Thank you.

GrantSmith

Is Domo interpreting your initial string as a date and the column is a timestamp data type?

There a function called STR_TO_DATE which will allow you to convert a string to a date type object based on the format string you pass in. Alternatively you can do TIMESTAMP() to convert your string to a timestamp since it's in the standard format.

Then you can use the DATE_FORMAT function on a date/timestamp field to return a string with the specific format you specify. You can read more on the format codes here: https://domo-support.domo.com/s/article/360043429953?language=en_US

jessdoe

You can do replace(`date_column`, 'T', ' ') with a space in between the final single quotes to indicate you want to replace all occurrance of 'T' with a space. This will also convert your date column to a string.

Alternatively, if you just want to remove the time part of datetime column, you can use the date function date(`date_column`) will only return the date part of the data.

GrantSmith

Is Domo interpreting your initial string as a date and the column is a timestamp data type?

There a function called STR_TO_DATE which will allow you to convert a string to a date type object based on the format string you pass in. Alternatively you can do TIMESTAMP() to convert your string to a timestamp since it's in the standard format.

Then you can use the DATE_FORMAT function on a date/timestamp field to return a string with the specific format you specify. You can read more on the format codes here: https://domo-support.domo.com/s/article/360043429953?language=en_US