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?

Contributors

Replies

1 Day

Discussion Span

1 Year Ago

Last Updated

Views

Lek Plepi

Newbie Poster

Banned

15 posts since Sep 2011

Reputation Points: 1

Solved Threads: 0

Skill Endorsements: 0

1 Year 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,968 posts since Feb 2007

Reputation Points: 722

Solved Threads: 457

Skill Endorsements: 20

1 Year 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

Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

You