I'm a new user, and I'm having some newbie issues related to compare times and if statements.
I'm trying to compare whether the current time is before 18:00 in an IF statement.
In the IF statement, I selected the “If all the following are true” option and then added the condition calculation. Inside the calculation field I tried the NOW()<18:00 however this formula or statement is in red and I don't know how to make it work.
Any approach options on how to do this will be appreciated.