Text to Date/Time in Sharepoint list

Hi Suravi195 ,

you could create a new calculated column.

First click "Add column" and then scroll down to "See all column types"

Create a new column and name it "DDR Expected Formatted" and select "Calculated (calculation based on other columns)" as the type

Paste the following into the Formular field (I assume your column is titled "DDR Expected")

=DATEVALUE(LEFT([DDR Expected],10))+TIMEVALUE(RIGHT([DDR Expected],8))

 Now set the data type to "Date and Time" and the "Date and Time Format" to "Date & Time"

You will get a new column with the type "Datetime" that contains the parsed date values from your text column.

Best Regards,
Sven