Hi
try using date.Today.Day to get todays Day.

or if you are using full dates you can compare the no of days using sqlce built in function of DATEDIFF (d, OrderDate, ShippedDate)

Dim mycommand1 As New SqlCeCommand("select * from Appointments where Day > " & date.today.today & "", cn)



also execute the command as scalar so it will return you a value if you are using the datediff