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"


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.