Round down the Date to the hour

[saqib]

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

[MarqueeCrew · Accepted solution]

Try

Datetimetrim([date field],”hour”)

Cheers,

Mark

[JoshKushner]

Try this formula.

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

[JoshKushner]

Actually go with @MarqueeCrew's answer.

[MarqueeCrew]

@JoshKushner,

I like your style :)

[JoshKushner]

You constantly teach me new things @MarqueeCrew. Much appreciated. 😊

[jdunkerley79]

I'd go with @MarqueeCrew for clarity but I would probably use an adjusted version of @JoshKushner myself:

Left([Datetime],14)+":00:00"