5 Replies Latest reply: Aug 16, 2012 5:39 AM by Kiran Rokkam RSS

    Count within 7 days or N number of days.

    Shubham Kumar

      Hi,

       

      I have a scanario where I need to find the number of days. I have two days between I need to find. What is the best approach to find the day. Right now I am using interval ( one date field - another date field) <7, then count so particular column. Need some more optimized query to perform this operation.

       

      Best Regards,

      SKumar