Remove seconds from datetime

[stribor45]

When I add a custom column I am able to get exactly what I want in my datetime (datetime without seconds) but as soon as I convert the type of custom column to datetime and end up again with seconds.  How do I get rid of ss in datetime?

Thanks

[Ritaf1983]

Hi @stribor45 
With/without seconds is the format, not "data type" .
You can modify it from the data view.
Choose one that you need from the list / you can also customize it manually

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[stribor45]

I want to remove the seconds within the power query editor not in the data view

[Ritaf1983 · Accepted solution]

Hi @stribor45 

Try to follow this tutorial :
https://blog.enterprisedna.co/datetime-value-how-to-strip-off-seconds/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ashish_Mathur]

Hi,

If you want to get rid of the time stamp from the entries in the Date column, then just change the Data Type of that column to Date.

[stribor45]

I don't want to remove time from Date column. I want to keep it the same and just remove the seconds