Forum Discussion

Suravi195's avatar
Suravi195
Copper Contributor
Aug 14, 2023

Text to Date/Time in Sharepoint list

Hi, 

 

I have a sharepoint list that has date/time data in text format as below. I want to extract the data in data/time type in a new column. How do I do this? 
05/03/2024 00:00:00 

 

SharePoint Online

1 Reply

Sort By
  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Aug 15, 2023

    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

Resources