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


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.


Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

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

    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!**