I was having problem with my query formula. it does not filter the range of my values which depends on the date ranges that I have put up.Here is my formula:=query(all!B2:G, select B,C,D,G where date '&text(all!B2:B, mm-dd-yyyy)&' >= date '&text(E2, mm-dd-yyyy)&' and date '&text(all!B2:B, mm-dd-yyyy)&' <= date '&text(E3, mm-dd-yyyy)&' order by B DESC  label B'Date of Purchase', C 'OR Number', D 'Particulars', G 'Total Expenses' )
Using date as filter for my query formula
google spreadsheets;google spreadsheets query