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 ti...
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 .