now() to show and hide text box

[#1]

Hi all

Has anyone tried to show and hide a text box for a particular hour depending on the time of the day using now() function.

Example: in the Text box conditional layout I have date(now(),'hh')=15 when the time is 15:09:10 the text box disappears. Weird!!

Regards

Koushik Vutha

[its_anandrjs]

Hi,

In the layout properties write like

=if( date(now(),'hh:mm:ss') = '15:09:10',0,1)

Regards

Anand

[lironbaram]

you can use

floor(frac(now())*24) =15

[datanibbler]

Hi,

what about trying the TIME() function?

Best regards,

DataNibbler

[MarcoWedel]

Hour(Now())=15

[MarcoWedel]

or as a string comparison, maybe

Text(Date(now(),'hh'))='15'