How to remove minutes from current time?

AppSheet AppSheet Q&A
1

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.

2

subtract the minute.

example

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

3

@jaichith Thanks your reply.

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

Thanks.

4

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

1 Like
5 
DATETIME(
  DATE(NOW()) & " " &
  TEXT(HOUR(TIME(NOW()) - "00:00:00")) & ":00:00"
)
6

It works. Thank you so much.

1 Like
7

Welcome !!! :blush: