Android Current Week from SQLite

select * from order_master WHERE om_date BETWEEN date('now', 'Weekday 1', '-7 days') AND date('now')


this code for previous week

SELECT  * FROM  order_master
    WHERE strftime('%Y-%m-%d',om_date) >= date('now','-14 days') AND
    strftime('%Y-%m-%d',om_date)<=date('now') order by om_date LIMIT 6