[RESOLVED] Working with dates... How to check if a certain date is between a certain period?

[Hamsori]

I'm trying to find a VB code that checks if my date on a label is between a certain dateperiond that is chosen from two DateTimePickers...

I'm trying something like:

Dim MyDate as Datetime = Convert.ToDateTime(LabelDate.Text)
If MyDate <> between DateTimePicker1.Value and DateTimePicker2.Value Then
.......
End If

(I tried to do this with a query, but I'm using SQL Server Compact, and it does not allow me to do:
... WHERE NOT @MyDate BETWEEN @Val1 AND @Val2