I suggest you to store date value as an string value and to search over
the string value. For example if user selects a date 2010-10-20, your
code should translate it into a string value
"20101020" before it saves it into the database. After this value is
stored as a string, you can use it in
I want retrieve invoice numbers depending upon items e.g.
InvoiceNoItem InvoiceDate
10 item_a
11 item_a
11 item_b
11 item_z
12 item_a
12 item_c
12 item_x
13 item_a
13 item_x
User can search on item(s) and can also include period (invo
