By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,097 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,097 IT Pros & Developers. It's quick & easy.

Date Comparison !! Please Lend a hand to Beginner

P: 3
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....
Mar 29 '07 #1
Share this Question
Share on Google+
1 Reply


100+
P: 375
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
Mar 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.