tag:blogger.com,1999:blog-1434458166860676036.post4880098811017513226..comments2023-10-05T13:20:23.298+01:00Comments on TechyGypo: .NET Round Date to Nearest HourSuperGypohttp://www.blogger.com/profile/01703215874245708542noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1434458166860676036.post-58730278227295393872017-07-17T11:31:10.301+01:002017-07-17T11:31:10.301+01:00used the basis of this to create function to round...used the basis of this to create function to round to next hour for a transaction count refresh point. Worked well!<br />Tony Shttps://www.blogger.com/profile/13115693201453682159noreply@blogger.comtag:blogger.com,1999:blog-1434458166860676036.post-69260440554474940702017-06-23T10:56:55.344+01:002017-06-23T10:56:55.344+01:00Pleased it helped :)Pleased it helped :)SuperGypohttps://www.blogger.com/profile/01703215874245708542noreply@blogger.comtag:blogger.com,1999:blog-1434458166860676036.post-15616124474962441892017-06-23T09:07:13.054+01:002017-06-23T09:07:13.054+01:00Thank you so much for this example (VB.NET) I was ...Thank you so much for this example (VB.NET) I was looking for a way to supply an SQL query for records between the last hour and this one. <br /><br />I modified your function slightly, iif(dt.minute >= 0, dt.addhours(-1),dt) to get last hour.VB Learnerhttps://www.blogger.com/profile/07777912711598602995noreply@blogger.com