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?

Recommended Answers

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.

Jump to Post

All 2 Replies

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.

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.

commented: agree +13
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.