Forum Discussion

Switto's avatar
Switto
Helper IV
4 years ago
Solved

Date format issue

Hi,

I have multiple date columns coming from SP as "Fri Nov 19 2021 19:31:44 GMT+0530 (India Standard Time)" this format and while converting into date, it is showing error. Any idea how to convert it ?

Thanks in advance ,

Switto

Need Help
  • Switto's avatar
    Switto
    4 years ago

    Hi All, We did some research and tried the option "Extract" and than "Range"  in Add column in Power query  as the data is same in all rows and worked fine. 

5 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    Switto , Follow the below steps:

     

    Step 1: Go to Power Query Editor

    Step 2: Select your Date column and right click on it and select Split column 

    Step 3: Enter 15 like below and choose the first option

    Step 4: You'll get the answer in the first column like this:

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Switto .
    If it's data format is text, then you can't directly convert it to a date format.
    Which mode did you use to import the file into your Power BI desktop?
    You will need to change your format from there only.


    Regards,
    Sanket 

    If this post helps you give it a 👍 and if it solved your issue consider Accept it as the solution.

    • Switto's avatar
      Switto
      Helper IV
      4 years ago

      Anonymous , Thanks for the quick reply. As it is an online ShrePoint list, I have connected data through SP Online list option.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Okay.
        Then I would advise you to change its format in the Share Point list.

  • Switto's avatar
    Switto
    Helper IV
    4 years ago

    Hi All, We did some research and tried the option "Extract" and than "Range"  in Add column in Power query  as the data is same in all rows and worked fine.