Computer Geeks

Computer Geeks

Geek Shop

Geek News

Geek Stuff

Science Geek

Computer Gaming

Linux Chat

Building Websites

Computer Forums

Computer Help Forum

Computer Hardware Forum

Computer Software Programs


Go Back   Computer Forums > Geek Stuff

Geek Stuff General forum for discussing anything geek. If your topic doesn't fit in any of the other forums then post it here.

Computer Geeks
» Active Discussions
Computer Geeks
No Threads to Display.
» Other Websites
- Software Publishing

- Server Hardening
Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2008, 06:59 AM
snachala snachala is offline
Junior Member
GB Beginner
 
Join Date: Mar 2008
Posts: 15
Default BindingSource Filter Between Two Given Date

Hi All,
Im thinking if it is possible to filter records based on date1 and date2.
All this time Im using a different approach to filter it. I just put the
command like

"Select * From Invoices Where InvoicesDate Between DateValue('" + SelectedDate1.ToShortDateString + "') And DateValue('" + SelectedDate2.ToShortDateString + "') ORDER BY SO_NO DESC"


I've been using bindingsource.filter to filter it for a certain date but
is it possible if i select all records and filter it between a period?
What the syntax would be like to filter it between two given dates?


Thanx
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Powered by vBadvanced CMPS v3.2.3

All times are GMT -5. The time now is 07:54 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
HTML Help provided by HTML Help Central.