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

Hello Siddhi, Please see old post for some reference and direction - [image] Convert String to Date Type Question & Answer 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.…

its not helping me…my date contains 12 letters

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

String to date conversion

Q&A

Deep September 13, 2024, 7:35am 5

Seems solved in other thread

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

Topic		Replies	Views
Convert String to Date Type Q&A quick-sight , Business-Intelligence-Engineer , data-label	2	2975	November 12, 2023
How to convert string format YYYYMMdd to date Q&A formatting , date , quick-sight , calculations	7	2332	June 20, 2023
Unable to convert string data type to date data type Q&A data-source , formatting , date , quick-sight	8	3130	January 21, 2025
Converting string to date Q&A date , quick-sight , calculations	4	1047	May 3, 2024
ParseDate returns nulls Q&A error , quick-sight , Business-Intelligence-Engineer	1	78	May 7, 2025

String to date conversion

Related topics