convert date format of "created_at" from Twitter API to %Y-%m-%d %H:%M:%S

[Anonymous]

Hi Experts,

I want to convert the date format of "created_at" from twitter API to the format as "%Y-%m-%d %H:%M:%S", throuth Python or other ways.

I've downloaded Python and can use it on Power Query of BI.

Sorry for not knowing exact script of Python on BI, could you please kindly tell me the script?

Best regards.

[Anonymous]

Thank you for your quick reply!

It is the example of the date format of "created_at" column and the date format that I want to convert.

from

Wed Jun 30 14:54:36 +0000 2021

to

2021-6-30 14:54:36

Best regards,

[Fowmy · Accepted solution]

@Anonymous 

I added a custom column in PQ to convert the given date-time to the desired format. Please check the attached file. You can do further formatting in Power BI once you load the table to the model.

let
m = Text.Middle([Column1],4,3),
d = Text.Middle([Column1],8,2),
y = Text.End([Column1],4),
t= Text.Middle([Column1],11,8)
in
DateTime.FromText ( y &"-"& m &"-"& d &" "& t 
)

[Anonymous]

Dear Fowmy

It works!!

I really appreciate your help!

[Fowmy]

@Anonymous 

Can you share some sample dates for "Created Date"? This can be done using M in PQ