Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > visual basic > answers

Date Comparison !! Please Lend a hand to Beginner

Newbie
  
Join Date: Mar 2007
Posts: 3
#1: Mar 29 '07
how to know if the current date is between 2 date !!!
erm , for example

rsMovie![StartDate] <= Combo2.Text <= .rsMovie![EndDate]

how to know the date that i select in combo is between the start date and end date...
Urgent Need Help pls....
Needs Regular Fix
  
Join Date: Jan 2007
Posts: 365
#2: Mar 30 '07

re: Date Comparison !! Please Lend a hand to Beginner

Quote:

Originally Posted by Dayon

how to know if the current date is between 2 date !!!
erm , for example

rsMovie![StartDate] <= Combo2.Text <= .rsMovie![EndDate]

how to know the date that i select in combo is between the start date and end date...
Urgent Need Help pls....

First change combo2.text to date format
Dim Chk as Date
Chk=cdate(Combo2.Text)
if (chk<=rsMovie![StartDate] and chk>=rsMovie![EndDate])
msgbox "Date is in between"
else
msgbox "Not in between"
endif
Reply

« previous question | next question »

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved