Wrox Programmer Forums
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 22nd, 2007, 10:58 AM
Authorized User
 
Join Date: Jul 2006
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to naveed77 Send a message via Yahoo to naveed77
Default data between dates

dear readers,

i m working on a project in which i have to find records between two dates. i.e. from date and to date, but one field should be used where date is being stored. so how can i use that field to find records.? plz tell me by using codes for that. ( except Woodyz sorry mr. woodyz)

thnx in advance.
 
Old January 22nd, 2007, 01:46 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 627
Thanks: 0
Thanked 0 Times in 0 Posts
Default

select * from yourTasble where dateField > dateMin and dateField < dateMax

"There are two ways to write error-free programs. Only the third one works."
Unknown
 
Old January 23rd, 2007, 06:57 AM
Authorized User
 
Join Date: Jul 2006
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to naveed77 Send a message via Yahoo to naveed77
Default

thnq dear frnd,i will now apply if i find any mistake i must contact u





Similar Threads
Thread Thread Starter Forum Replies Last Post
dates again dhoward VB.NET 2002/2003 Basics 12 August 22nd, 2007 09:48 AM
VBA code for entering the same data for dates rohit_ghosh Access VBA 1 May 3rd, 2007 09:45 AM
Problem with selecting data between two dates serf SQL Language 1 January 18th, 2006 01:16 PM
between dates capitala Access VBA 1 May 30th, 2004 05:20 PM
Dates oathamm Servlets 1 June 27th, 2003 05:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.