Skillwave Training @skillwave.training · May 11 In an Ask Ken Anything (AKA) session last month, one of our students asked a question that many #PowerQuery users have quietly wondered about but rarely voiced: "Why do I need TWO change type steps just to get from a date-time to a plain date?" 😠 The frustration is real! 🧵
0 likes 1 replies
?
Replies
When importing CSV files from an external system with a date-time field, PQ refuses to convert directly to a date type. It throws an error unless you: 1️⃣Convert to date-time, and then 2️⃣Add a second step to strip the time component. There is no native shortcut that eliminates this two-step dance. 👢🎵