String to date

Sbhatia

I am trying to convert a text column to a date but my beast mode is not working, I am trying to add a formula in my etl to convert it

Sbhatia

thanks for your fast response, much appreciated!

nmizzell

Your Date format string is incorrect. You can view the list of valid strings here https://domo-support.domo.com/s/article/360043429953?language=en_US .

The following beastmode would produce the desired effect:

date_format(`Date`,'%Y-%m-%d')

Sbhatia

thanks for your fast response, much appreciated!

Sbhatia

My result also has a timestamp when I have not requested this, how can I remove this?

Sbhatia

I have resolved this

pauljames

@Sbhatia , alter columns tile. :)