String to date

Sbhatia · 2023-11-02T14:44:31+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

thanks for your fast response, much appreciated!

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')

thanks for your fast response, much appreciated!

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

I have resolved this

@Sbhatia , alter columns tile. :)