Forum Discussion
anthonyg1986
4 years agoRegular Visitor
Dates value changes after schedule refresh
Hi I have a table with one column which is a date value only and the latest date value is 9/11/22. the date is linked to a number of other tables and runs as expected on my on prem version of Power...
Icey
4 years agoCommunity Support
Hi anthonyg1986 ,
Another speculation:
Do you mean that the date format changed from "m/dd/yy" or "d/mm/yy" to "yy/mm/dd"?
If so, please change the data type in Power Query by "Using Locale...".
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.