time comparison in set analysis

[laujerry]

i want to filter data according to the time field "create_time" in an expression:

Count(

   {$<

      [create_time]={'>=$(=$(time_1530))'}

   >}

   DISTINCT [order#]

)

"time_1530" is defined as Time#('15:30')

then it shows no data at all

by removing the set analysis the result shows properly

so is there any problem with my expression?

thanks for any help

[#2]

Can you upload your sample QVW?

[laujerry]

well it seems not working

[laujerry]

hi all, please find the attached file for my issue

thanks all for helping again

[#5 · Accepted solution]

Hi Jerry,

     Would like to know is the field "create_time" really a time? Why I asked this is because when I convert it to a number by using num(create_time), it gives me a negative number. But your variable time_1530 is a positive number and that's why your formula does not work. If you can get the field create_time back to a normal time field, everything should work ok.

Herman

[laujerry]

i reloaded with Time#(create_time,'hh:mm:ss') and it's all done

thanks a lot!

[laujerry]

so it turns out that u are rite Garcia..

then i don't understand why the text object testing works