Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The problem is that even thought he presentation is an integer, this is still a timestamp, so if you add the hour function, you convert it to an integer..
=if(hour <= hour(Date(Now(),'hh')), hour, NULL())
Yes, that did it! I had tried using =if(hour <= Num(Date(Now(),'hh')), hour, NULL()) to convert it to a integer but wasn't getting any useful results. Didn't think to convert using hour(). Thank you!
hi
FYI: Simply, you can use hour function instead of hour(Date(Now(),'hh'))
=hour(Now())