Can you convert Date to Text in DOMO?

arzconci
arzconci Member
edited November 2023 in Connectors

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.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • jessdoe
    jessdoe Contributor

    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
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories