Forum Discussion

mcdermjj's avatar
mcdermjj
New Member
3 years ago

Convert String to date and time

Hi There 

I would like to convert the string formats below in my DATETIME column into a useable Date and Time Column such as 2023/06/16 22:45:00 , so Power Bi can recognise it as  a real Date and time  format for use. Thanks

2023061612245000
2023061612244900
2023061612244800

3 Replies

  • devanshi's avatar
    devanshi
    Helper V
    3 years ago

    Just select the that column & change datatype text to date/time. It automatically convert in date time formate

    • mcdermjj's avatar
      mcdermjj
      New Member
      3 years ago

      Hi there, unfortunatley that gave me  error 😞  so trying adding a column and extracting the first 8 Characters. for date and then changing data type to date ( That seems to work ) and then Just trying the last 8 for time and its not working for data type change for time.. will keep trying 

       

      • devanshi's avatar
        devanshi
        Helper V
        3 years ago

        Try this one,
        Go to transform tab, then 

        Click one from this , select date/time datatype .