Forum Discussion
Solved
split or extract?
Hi, I have a column including datetime that the format is 2025-07-07 at 12:40. Which one solution is better? "split by using delimiter at" or "apply a tramsform to extract the column first 11 cha...
mamatea1218 If format is constant then extracting first 11 characters is good because Extracting a fixed number of characters is generally faster and less error-prone and It is straightforward if the date part is always exactly 11 characters long.
If there is any possibility of variation in the format, splitting by delimiter might be a safer choice.
HarishKM
Super User
Super UserHey mamatea1218,
If I have to extract date, I will follow below steps.
Step 1 - open Power query editor
2- choose add column from top ribbon.
3- select your date column
4 - select date drop down then select date only
5 - BINGO now you have your date column
Thanks
Harish M
Please accept this as a solution if this solves your problem and give kudos as well.