Member Avatar for Lek Plepi

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?

  • 3 Contributors
  • 2 Replies
  • 139 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by sgt_toasty
Member Avatar for debasisdas

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.

Member Avatar for sgt_toasty

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.