String to Date and Time is giving issue and not able to resove

I am using a simple date format here

My Data

00000000

Want to convert it to Date format

and it works for one column and fails for the other two

the one it worked :slight_smile:

The other 2 which fails

please help