how to validate database date is greater than today's date

Hi,

if(convert(datetime,REPLACE ('1st oct 2014', 'st', ''),101)>convert(datetime,CONVERT(VARCHAR, GETDATE(), 101),101))
BEGIN

END 
 Print 1
ELSE

BEGIN 
 print 2
END

i have used the your value for example .
you can replace it with your column.

Let me knowif you need more on this.

Abhishek

DateTime dtNow = DateTime.Now;
dtNow = new DateTime(dtNow.Year, dtNow.Month, dtNow.Day);

if(MedicalEntryDate >= dtNow.AddDays(1))
{
}
else
{
}

The first two lines calculate the current date. The if statement compares the MedicalEntryDate with tomorrows date (dtNow plus one day).

Not tested, just from the head.