String to date conversion

[Siddhi_21]

parseDate(concat(substring(toString({DATE}), 1, 2), “-”, substring(toString({DATE}), 3, 2), “-”, substring(toString({DATE}),5,2)), “yy/MM/dd”)

showing error

[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

[Siddhi_21]

its not helping me…my date contains 12 letters

[Deep]

Hello Siddhi,

Could you share how your date string field looks like so that other members can also look into and recommend ?

Thank you.

Cheers,
Deep

[Deep]

Seems solved in other thread

– Date -12 digit integer to a date conversion - #9 by Xclipse