Converting datetime to date shifts date back one day

[moody31415]

I have a dataset that has an "Event_Week" field that looks like this:

12/9/2018 12:00:00 AM +00:00

When I run this powerbi type change

= Table.TransformColumnTypes(KustoQuery,{{"Event_Week", type date}})

then the value looks like this:

12/8/2018

Why are my dates being adjusted "minus one day"? 

[v-qiuyu-msft]

Hi @moody31415,

Please try to change data type to Date/Time then check the result. I guess the result is affected by your OS time zone settings. 

Best Regards,
Qiuyun Yu