SQL datetime and calendar.selectedDate in asp format issue
I am building an appointment booking system web application in asp.net in VB,

Im simply trying to check whether an appointment has been made on a date selected from the calendar control.  I am using Linq for the bindings but the format from the calendar is mmddyyyy  when i need ddmmyyyy, my appointments entered int sql table as are 20/09/2012 10:00:00

trying to use a linq from p in db.apps
where p.date=mycontrol.selecteddate

does not yield results
SQL datetime and calendar.selectedDate in asp format issue
===

I am building an appointment booking system web application in asp.net in VB,

Im simply trying to check whether an appointment has been made on a date selected from the calendar control.  I am using Linq for the bindings but the format from the calendar is mmddyyyy  when i need ddmmyyyy, my appointments entered int sql table as are 20/09/2012 10:00:00

trying to use a linq from p in db.apps
where p.date=mycontrol.selecteddate

does not yield results