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



      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,