Trying to get the count.

[#1]

I have data as below...

ID  DateEnd

1  

2

3   10/31/2016.

Trying to get the count of ID's which has Date > today () and I am using the below expression,

count(if(date([DateEnd] >Today() ),[ID]))  but  it is not working

THnaks much

[swuehl]

Pavana alva wrote:

yeah...when I put in listbox it is in the following format....10/31/2016

So I guess you either haven't read Henric's blog post (which I would recommend anyway) I've linked to or you haven't closely looked at the images titled 'correct' and 'incorrect' .

[#3]

Yeah.My bad.Thank you very mcuh