Equivalent of DayStart for Hours?

[rmnvncnt]

I'm trying to reproduce the result of DayStart() in the backend but at the hour level. My input data consists in 'DD/MM/YYYY hh:mm:ss' timestamps.

I tried this :

Timestamp(Floor(($(vTransactionDateTime) * 24) / 24))

but it returns rounded up data to the day level.

Any idea?

[sunny_talwar · Accepted solution]

Try this

Timestamp(Floor($(vTransactionDateTime), 1/24))