How I can apply conditional filter to count values?

[#1]

Hi,

I have a problem, im new user in QV, I have the next table:

DATE_CREATION                  ID                 STATE

        15/5/15                       Q123456             PROC

        16/5/15                       Q789101             PROC

        16/5/15                       Q112131                EP

        14/5/15                       Q312456                EU

        12/5/15                       Q789121             PROC

        17/5/15                       Q152131                EP

        28/5/15                       Q153456             PROC

        28/5/15                       Q789131             PROC

        28/5/15                       Q192131                EP

I need count IDs in PROC that have expired more than 1 day (TODAY)

The result should be= 3.      (Q123456, Q789101,Q789121)

Please.

[pokassov]

Hello!

Count({$<DATE_CREATION={'<$(=date(today()))'}, STATE={PROC}>} ID)

[#3]

Hi Cepren,

It is exactly what I was looking for.

Thank you very much.