Hi there!
How can we identify the time of the day? (morning, afternoon and night)
I made this expression but is mistaken the time of the day…
CONCATENATE("¡Hola ",[Nombre], " “,
IFS(TIMENOW()>=“00:00:00”,” good night! “,
TIMENOW()>=“07:00:00”,” good morning! “,
TIMENOW()>=“12:01:00”,” good afternoon! ",
true,
“no aplica”
)
)
Thanks!
Solved! Go to Solution.
Hi,
There is a way to do this with the hour function. I got something similar working with:
IFS(
HOUR(TIMENOW() - "00:00:00") > 12, "Good afternoon!",
HOUR(TIMENOW() - "00:00:00") > 7, "Good morning!",
HOUR(TIMENOW() - "00:00:00") > 0, "Good night!")
You have to subtract “00:00:00” from TIMENOW()
because the function is meant to operate on intervals rather than absolute times.
Hi,
There is a way to do this with the hour function. I got something similar working with:
IFS(
HOUR(TIMENOW() - "00:00:00") > 12, "Good afternoon!",
HOUR(TIMENOW() - "00:00:00") > 7, "Good morning!",
HOUR(TIMENOW() - "00:00:00") > 0, "Good night!")
You have to subtract “00:00:00” from TIMENOW()
because the function is meant to operate on intervals rather than absolute times.
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |