Problem with if statement

[Lisa_P]

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())

[bsocks_11415]

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!

[MayilVahanan]

hi

FYI: Simply, you can use hour function instead of hour(Date(Now(),'hh'))

=hour(Now())