Extract a date using Power Query Formula (M)

[longlivecoops]

Hi guys,

Am just starting out with using Power Query Formula.

How can I extract the date from a cell that reads:

01/31/2016 5:00:30 PM

I want it to be in DD/MM/YYYY format.

The fact that the month comes at the beginning is throwing me off.

Is it Date.FromText?

Thanks

 

[anvg]

Hi

Is it Date.FromText?

Yes

let
    textDate = "01/31/2016 5:00:30 PM",
    return = DateTime.FromText(textDate, "en-US")
in
    return

Regards,