expression help

[#1]

Im trying to make an expression from a list of dates.

I want to count all items from last year, - so something like this

count   (if(year(DATE)-1, ITEMS))

but this doent work???

[manideep78]

Try this,

Count({<Year={">=$(=Year(DATE)-1)"}>}items)

[#3]

Try tihis ,

Count ( {<Year(MyDateField)={'>=$(=Year(Today())-1)'} >} ITEMS)

//yusuf

[jagan]

Hi,

Try like this

=Count({<Date={">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}items)

Hope this helps you.

Regards,

Jagan.