I don't understand why the result of the filter is what you can see in the picture. Can anyone help me?


Hi Rui,

What records would you expect not to see in this Aggregate? At what time did you execute this?

I execute at 14:55:00. I expected to see id=2 and id=12.

Are you on the same timezone as the server? Does CurrTime() return the value you're expecting? The logic on your filter looks sound, so we should make sure the problem isn't the inputs.


hello can you go to service center and check what time is it in there?

Or can you do a debug and check what time does currtime is returning?




I was out of office.

I understood your last reply and I solved my problem.