Skip to content

    • Beast Mode

    Beast Mode

    Hi Team, Need help in converting a string value to date.

    Member
    in Beast Mode

    Hi Team, I have a column which is has string values. This column has data related to months and years. Example : Jan-23. The problem is when i am using this column in the chart, its not detected as a date and so i do not get options to filter month and year. I want a way by which i can convert these to a date value. And the result should show like Jan 23 and should be detected as a date.

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      What does your function look like? You should be able to do something like this:

      1. STR_TO_DATE(`str_field`, '%b-%y')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach

      You can use the STR_TO_DATE function in a beast mode or a formula tile in a magic ETL to convert a string to a date based on the format string.

      Documentation: Site faviconCustomer Support Community

      Site faviconCustomer Support Community

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

      I have limitations to edit it in etl. I can only do it in the beast mode. But as my data values only have Jan-23, Jun-23, May-22 etc, this is not letting me apply str to date.

    • Coach
      Answer ✓

      What does your function look like? You should be able to do something like this:

      1. STR_TO_DATE(`str_field`, '%b-%y')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thank you, This worked. There were spaces in data, after removing spaces it has worked.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories