[dba-SQLServer] Date problem

is this in TSQL?  why is there a "pro." prefix in the expression? afaik it 
should be technically possible to use < operator for date expressions.  
maybe it thinks either "pro.ModifiedDate" or "dte" is not a date.

Billy
ps. some people think having coffee is also not considered a date; only 
movie and dinner


>From: "Susan Harkins" <harkinsss at bellsouth.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "SQLList" <dba-SQLServer at databaseadvisors.com>
>Subject: [dba-SQLServer] Date problem
>Date: Fri, 10 Mar 2006 11:31:21 -0500
>
>I'm trying to use a date in an expression
>
>If pro.ModifiedDate < dte Then
>
>But SQL Server gives me an error -- first it says I can't use the < 
>operator
>with Date. What's up with that?
>
>Susan H.
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>