How to remove minutes from current time?

[leinharte]

Hi,

There is the column which type is a DateTime, and the initial value is now(). How to remove minutes from current time?

ex) 2024-07-03 15:33   =>   2024-07-03 15:00

Thanks.

[jaichith]

subtract the minute. 

example

DATETIME((NOW()-MINUTE(NOW()))

[leinharte]

@jaichith  Thanks your reply.

It does' t work.
There is an error message: Parameter 1 of function MINUTE is of the wrong type.

Thanks.

[jaichith]

DATETIME(
  DATE(NOW()) & " " &
  TEXT(HOUR(TIME(NOW()) - "00:00:00")) & ":00:00"
)

[jaichith · Accepted solution]

DATETIME(
DATE(NOW()) & " " &
TEXT(HOUR(TIME(NOW()) - "00:00:00")) & ":00:00"
)

[leinharte]

It works. Thank you so much.

[jaichith]

Welcome !!!😊