How do I make a calculation with Today() in a Set analyses?

[#1]

I want to count the number of incidences where the datafield ( a date) is BEFORE today. I have tried this

Count({1<Deadline_Date={'<Today()'}>} Deadline_Date)

but it does give me the result

[jyothish8807]

Hi Soren,

Create a field in script:

in script:

Load

Deadline_Date,

Date(floor(Deadline_Date),'DD/MM/YYYY') as Deadline_Date_new

from <>;

In exp:

Count({<Deadline_Date_new={"< $(=date(Today(),'DD/MM/YYYY'))"}>} Deadline_Date)

Regards

KC