Convert a column of text to date\time\minute

[MichaelHutchens]

Hi folks, might someone help me convert the below to a date\time\minute format?

I've tried it in Power Query with the below, but I'm getting an error:

= Date.From(Text.From([Date Hour and Minute], "en-US"))

[Ajinkya369 · Accepted solution]

Hey @MichaelHutchens ,

Here is the exact solution for your problem. Follow the article posted by me: Convert text type data/time column to date/time data type column (xplorebi.com)

Thanks,

Ajinkya K ( Analytics Specialist)

Xplore BI 

[MichaelHutchens]

Oh lawd it worked. I was just entering data incorrectly. Thanks so much @Ajinkya369 🙂

[amitchandak]

@MichaelHutchens , Try DateTime.FromText([Date Hour and Minute])

Or for only Date

Date.FromText(Text.Start([Date Hour and Minute],8))

[MichaelHutchens]

Hi @amitchandak , when I try that I get the following error:

[ryan_mayu]

@MichaelHutchens 

pls try this

= Table.AddColumn(Source, "Custom", each #datetime(
    Number.FromText(Text.Start([Date Hour an Minute],4)),
    Number.FromText(Text.Range([Date Hour an Minute],4,2)),
    Number.FromText(Text.Range([Date Hour an Minute],6,2)),
    Number.FromText(Text.Range([Date Hour an Minute],8,2)),
    Number.FromText(Text.Range([Date Hour an Minute],10,2)),
    00))

[MichaelHutchens]

Hi @ryan_mayu , I'm getting this error:

I've verified that the field name is correct. Am I doing something wrong?