Power Query Date Format Conversion (single step)

[wlknsnBI]

Hi,

I'm getting dates back from an api which are either like (I can choose):

15/01/2020 15:03

or

2020-01-15T14:03:17Z

I would like to have these automatically set as Date field (so excluding time). Right now, they are considered both as Text by Power Query.

Until now, I've always used the first type and added two steps:

1) convert to date/time

2) convert date.

=> Skipping step 1 returns an error.

Is there a faster way to do this? For example wrapping a certain formula around these fields?

[AnkitBI · Accepted solution]

Hi @wlknsnBI 

Don't think there is one way process to convert as value is in DateTime. You can combine step1 and 2 in a single step like below.

= Table.TransformColumnTypes(Table.TransformColumnTypes(Source,{{"Column1", type datetime}}),{{"Column1", type date}})

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.