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
-9
Newbie Poster
Banned
Recommended Answers
Jump to PostAlso 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.
All 2 Replies
debasisdas
580
Posting Genius
Featured Poster
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.
sgt_toasty
13
Light Poster
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.
debasisdas
commented:
agree
+13
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.