Date type returning error on some queries

[Juan_AL]

Good evening, i have been strugling with some columns not wanting to converto to Date type. what is weird is that some columns from another querie and same format will transform just fine

now if i do the exact same thing on another querie with the same format

i get only errors... tried everything but just cant figure out whats going on

thanks in advance

[adudani]

What's the error message when you left click on the "Error",
a yellow highlight with the value on the bottom left with a message such as Data.Format Error  or similar ? will show

[Juan_AL]

Edit: found the error...