calendar compare date.

[Madeleine]

i want to check if the date selected is before the today date. if yes, i wish to return a message in the label.

if (Convert.ToDate Time(Calendar1. SelectedDate.Da te) = (Convert.ToDate Time(Calendar1. SelectedDate.Da te)))
{
Label1.Text += "Select date after or today date";
}






another prob is my datediff don't seem to work. anyway MPAnnouncement. date_posted is a column name in my annoncement table.

SELECT MPAnnouncement. announcement, MPAnnouncement. date_posted, MPAnnouncement. subject, MPUser.user_nam e FROM MPAnnouncement INNER JOIN MPUser ON MPAnnouncement. user_id = MPUser.user_id WHERE (MPAnnouncement .display_to = 'Industry') OR(MPAnnounceme nt.display_to = 'All') OR (MPAnnouncement .display_to LIKE '%I%') AND (DATEDIFF (d,MPAnnounceme nt.date_posted, GETDATE())=0)



thanks