Rounding down to nearest hour in date-time field

[Billbjr10]

Hello,



I have a field that has the date-time for a transaction. I'm trying to round the field down to the nearest hour.

For example:
8/20/2019 2:37:20 PM

Convert to:
8/20/2019 2:00:00 PM

I need to keep the date-time field formatted the same, just simply round down to the nearest hour. I also need to keep this as a date-time field and not a string.

Any thoughts?

[CJ_London]

suggest try this

datevalue(now())+format(timevalue(now()),"h")/24

substitute your date value for now()

[ArviLaanemets]

=CDate(Int(24*Now())/24)

[CJ_London]

that's a better solution