Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
3 years ago
Solved

Remove seconds from datetime

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

 

 

 

Need Help
Tips and Tricks

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    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's avatar
      stribor45
      Post Prodigy
      3 years ago

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

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    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