Forum Discussion
Solved
Convert DateTime into Date in Query Editor using M function
Hi, 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:...
Hi,
This should help.
Ashish_Mathur
Super User
Super UserHi,
This should help.
after this advanced editing, right click the Date/Time columns to change type to Date! No errors 😀