2 Replies Latest reply: May 2, 2014 7:38 AM by Manish Kachhia RSS

    Complex set analysis - dates.

    Kasia Cwik

      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?