c# - How do I fetch a particular record based on Last Week, The current week using datetime() function? -

i have sqlite db table contains date & time each item. how fetch records belongs current week , of previous week. tried doing datetime() function not find better solution/approach.

i'm trying xamarin form based application.

please let me know how can achived.

thanks in advance...

use date() function in clause. example i'm starting @ , getting last days of week date('now', 'weekday 6') , starting now, getting first day of next week, , -2 weeks date('now', 'weekday 0', '-14 day')

 select field1, field2 table   datefield < date('now', 'weekday 6') , datefield > date('now', 'weekday 0', '-14 day')