5 Replies Latest reply: Apr 23, 2013 12:33 PM by jagan mohan rao appala RSS

    Find Product with two different dates

      I have product sales data with history.A particular product has to be sold on some date ex:04/12/2013  as per March month end data.But as of today data that sale date for product  may change to 04/24/2013.I want find number of  distinct products with two sale dates (One old sale date ad one new sale date).All the history data and daily data are in same table with flags.I tried lot of expessions to find the number.But no solution so far.Any Suggestions?