If statement problem.

[#1]

Hi!

I have 2 listboxes with timestamps, HH:MM. Open and Close.

I want to check the current time to see if the store is open and or closed. So i want to return a 0 or 1.

This is my expression: if(time(now(1))>Open AND time(now(1))<Close, 1, 0)

But it does not work.

It shows 0 when the open is 11:00 and close is 23:00 and now the time(now) = 10:47

Thanks!!

[CELAMBARASAN]

Write a condition in the chart properties as

=time(Frac(now(1)))>Open AND time(Frac(now(1)))<Close and PRU = 'A' AND AREA = 'A'

[#3]

I still want it to return 0 or 1