I'm looking for the right function to replace a DateTime to a Date in M. The challenge is that the DateTime length may vary based on month and day number, so for example I have: 8/5/2017 12:00:00 AM OR 10/21/2019 12:00:00 AM
In both cases I need to keep only the date without the time and change it to: "mm/dd/yyyy".
I used the split function but that requires 2-3 steps in query. Not a big deal but I’m after adding a custom column with the right M formula that will get me the right result.
You can go to Query Editor, click on the left icon of the column name, then select the Date to change DateTime type to Date type. The corresponding M query uses the Table.TransformColumnTypes() function.
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.