Compare Time between date and stored time in variable

[#1]

Hello Friends,

I want to compare time between time of date and time in variable. But in calculation if always gives me wrong result.

please see below example.

Ex.

DT1	Time of DT1	Variable (p_time = '10:30')	Expected Result	Calculation =If((time(DT1,'hh:mm') <= p_time), '1','0')
27/05/2013 08:00:00	08:00	10:30	1	0
24/05/2013 08:30:00	08:30	10:30	1	0
24/05/2013 09:00:00	09:00	10:30	1	0
26/05/2013 10:40:00	10:40	10:30	0	0
26/05/2013 11:00:00	11:00	10:30	0	0

here in this example according to formula my result should be "Expected Result" but it always give me wrong  result.

I have attached this examle file as well.

Please help me to identify the problem.

Thanks

[Sokkorn · Accepted solution]

Hi dipak.nit,

1. Change your variable: p_time = Interval('10:00','hh:mm')

2. Compare expression should be like this

=If(Interval#(Time(DT1,'hh:mm'),'hh:mm') <= p_time, '1','0')

Regards,

Sokkorn

[#3]

Hi Sokkorn,

It is working now.

Thank you.

[#4]

Hi b. Sokkorn,

It's also solve my problem (y)

Thank you.