[android-developers] DateFilter

Hi everyone,
    Can some one tell me that how to retrieve data within two date range actully i am fetching data but only between 1 to 8,
  11 to 19,
  21 to 29,
   but i want date from 1 october to 31 october 2012,
  and also from october to november


my code is like this
KEY_CONTENT3  is date colmn.

Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, KEY_CONTENT3 + " BETWEEN ? AND ?", new String[]
                 {    fdate + " 00:00:00", sdate + " 23:59:59" }, null, null, null)

please help me if any oe have any idea

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en