If anyone could help with a Formula.
I tried this one and it will not work in the “Filter Condition”
AND(
HOUR([TimeStamp]) > HOUR(NOW()) - 4 + IF(MINUTE(NOW()) >= 20, 1, 0),
DATE([TimeStamp]) = DATE(NOW() - “4:00:00”)
)
I keep getting a “Parameter 1 of function HOUR is of the wrong type”
The Timestamp is “DateTime”
I have a google form supplying the data, when entries are added, I have figure out the copy function to the DB. But I can’t delete the entries after copy. So I want to only copy the last entry or any entry which was added since the last run which is on the hour at 20 after.
Thanks
Hi @CANA-IT
Here is the answer probably to your question, along with its solution: HOUR() - AppSheet Help
Common problems
HOUR(NOW()) (or any DateTime or Time value in place of NOW()) causes Expression Assistant to complain, Parameter 1 of function HOUR is of the wrong type. The argument must be a Duration value, not a DateTime or Time value. To fix, convert a DateTime value to a Time value with TIME(), then subtract a zero time to convert a Time value to a Duration value: HOUR(TIME(NOW()) - "00:00:00"). See also: [NOW()](https://support.google.com/appsheet/answer/10108119), [TIME()](https://support.google.com/appsheet/answer/10107367)
1 Like