String to date conversion

[Deep]

Hello Siddhi,

Please see old post for some reference and direction -

Convert String to Date Type

Hi, I’m trying to convert a string data field into a date field. I tried doing the three dots and changing the data type but I kept getting an error. I’ve also tried using a calculated field ParseDate function with no success as all rows get skipped. Below is an example of how the string looks that I’m trying to convert. The data is coming from a Glue table. [image] Any help would be greatly appreciated. Thanks

Convert String to Date Type

Hi, I’m trying to convert a string data field into a date field. I tried doing the three dots and changing the data type but I kept getting an error. I’ve also tried using a calculated field ParseDate function with no success as all rows get skipped. Below is an example of how the string looks that I’m trying to convert. The data is coming from a Glue table. [image] Any help would be greatly appreciated. Thanks

Hope this helps to get some direction.

Thank you.
Cheers,
Deep