Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date field missmatch

Currently, when dates are converted to ISO dates, we add a time component too (midnight). eg. 01/11/2014 -> '2014-11-01T00:00:00.000Z' This is fine for dates fall in winter (before clock change). H...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

 Please first convert the data type of these columns to Date/Time in Query Editor.

You can refer to these thread:

https://community.powerbi.com/t5/Desktop/Support-for-ISO-8601-Date-Time-format-DateTime-ToString-quot-O/m-p/309187 

https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-savings/m-p/789919 

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.