Filter between two dates

i have two DatePickers on form and I want filter between two dates.
So when i click search in lsitview display the dates between
can anyone tell me how to deal with?

Lek Plepi

Newbie Poster

Banned

15 posts since Sep 2011

Reputation Points: 1

Solved Threads: 0

8 Months Ago

You filter the dates from database by using BETWEEN operator. You need to format the dates into your database format before passing the same into the DB for processing.

debasisdas

Posting Genius

6,872 posts since Feb 2007

Reputation Points: 666

Solved Threads: 434

8 Months Ago

Show Comments

Also keep in mind that in most instances the between operator selects entries between your two dates AS WELL AS the two dates. So if you were doing between Jan 1st/ 2011 and September 12/2011 both Jan 1st and Sept 12 will be included.

sgt_toasty

Light Poster

28 posts since Apr 2011

Reputation Points: 23

Solved Threads: 1