String to date

Sbhatia Member

November 2023 in Beast Mode

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

0

Best Answer

• 

  Sbhatia Member

  November 2023 Answer ✓

  thanks for your fast response, much appreciated!

  0

Answers

• 

  nmizzell Contributor

  November 2023

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

  0
• 

  Sbhatia Member

  November 2023 Answer ✓

  thanks for your fast response, much appreciated!

  0
• 

  Sbhatia Member

  November 2023

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

  

  0
• 

  Sbhatia Member

  November 2023

  I have resolved this

  0
• 

  pauljames Contributor

  November 2023

  @Sbhatia , alter columns tile. :)

  IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  0