STR_TO_DATE

RayRay_H · 2023-09-20T13:39:54+00:00

There was an error rendering this rich post.

RayRay_H

Hi everyone,

I am facing a problem of transforming Text to Date type.

I have a column called Date. The format looks like this:

I used the following formula to transfer it to Date formate"

STR_TO_DATE('Date','%d-%b-%y')

but the following error message popped up.

Could you please tell me what's wrong with my formula?

Thank you in advance for the help.

Find more posts tagged with

Accepted answers

All comments

MichelleH

@RayRay_H It looks like there may be a space after the date in the error message. Try replacing the spaces with an empty string before using the STR_TO_DATE function

STR_TO_DATE(REPLACE(`Date`,' ',''),'%d-%b-%y')

RayRay_H

https://community-forums.domo.com/main/discussion/comment/77288#Comment_77288

Hi Michelle,

Thank you very much for your help. After I tried your formula, the error message is still there:

RayRay_H

https://community-forums.domo.com/main/discussion/comment/77380#Comment_77380

BTW, I am doing this in ETL not in Beastmode.

RayRay_H

https://community-forums.domo.com/main/discussion/comment/77288#Comment_77288

My problem was solved by using Alter Column tile - Custom Date feature. I am still wondering why the formula doesn't work though .