Forum Discussion
GunnerJ
Post Patron
Post PatronRounding Down Date/Time to Hourly level
This one is pretty straight forward but I haven't been able to find a solution yet.
I have 15 min interval data and I'd like to create a new column the rounds down to the nearest hour. so in this case the first 4 rows would all show the date/time "1/1/2022 6:00:00 AM". I can get it to show that if it's text but then it won't let me change the type to date for some reason. Has anyone had experience with this?
You should be able to do this with the ribbon.
2 Replies
- serpiva64
Solution Sage
Hi,
if you want to obtain this
you have to
- change type to text
-add custom column
- and then change again type to datetime
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
- AlexisOlson
Super User
You should be able to do this with the ribbon.
