DATE(DATEPARSE ( "yyyy-MM-dd", split([Date],'T',1) ))
let me know if that doesn't do the trick, and let me know the datasource (I did this with a text file)
Did you try a Custom Split using T as the separator and Split Off 1 Column?
I followed the steps mentioned by you, and i am able to convert the split date into date format. But, if you want time also after removing "T" follow below approach:
String date= have the extracted date.
1. split the column date format with "T", it will create two columns "string date - Split 1" and "string date - Split 2".
2. Create Time = TRIM( SPLIT( [string date - Split 2], "+", 1 ) )
3. Create DATE = [string date - Split 1]+" "+[Time] and change the data type to date time.
Got it, thanks guys!