title: get last week info from sqlite database
body: <p>I have a sqlite database in my project and I have 3 <code>year</code>,<code>month</code> and <code>day</code> fields. I want to get last week or last month information from my table and show it in a listView using cursor adapter. I don't know how to do that. my table is not very big also my records are sorted by date so iteration can be an answer. please help me in any way.</p>