Date Comparison !! Please Lend a hand to Beginner

[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....

[cmrhema]

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(Combo 2.Text)
if (chk<=rsMovie![StartDate] and chk>=rsMovie![EndDate])
msgbox "Date is in between"
else
msgbox "Not in between"
endif