Round down the Date to the hour

What is the best way to round down a date to the hour:

For e.g. 2015-05-04 21:41:56 should become 2015-05-04 21:00:00

Date Time

Accepted answers

Try

Datetimetrim([date field],”hour”)

Cheers,

Mark

Try

Datetimetrim([date field],”hour”)

Cheers,

Mark

Try this formula.

LEFT([date],14) + PadLeft(ToString(Floor(ToNumber(Substring([date],14,2))),0),2,'0')

Actually go with @MarqueeCrew's answer.