Complex set analysis - dates.

[#1]

Hi,

I have to display a metric: number of items that have been in the database for over a year and don't have a review data or an owner.

These are the fields I need for it:

ItemID

Owner - owner of the item

PublishDate - when items was added

vToday - variable - todays date

I'm not sure how to tackle this. Any ideas?

[anbu1984 · Accepted solution]

Count({<Owner={"=len(trim(Owner))=0"},PublishDate={"$(= '>=' & date(vToday) & '<=' & date(vToday-365))"}>}ItemID)

[MK_QSL]

Provide some sample data please !