Hi Everyone,
Thank you for the time you spend to look at the post.
I am required to retrieve report based on a date field in the table. the date field filtering must be from the previous month of the 6th till this month of the 5th.
For example, today is 5th November 2013, I need report from 6th October to 5th November.
Can someone give me some hint how doing it? I tried DATEDIFF and DATEADD, but just couldn't figure out how it should be. I hope someone will assist me by just dropping me hints.
Please let me know if explaination needed.