From: johansson.andersson@telia.com   
      
   Hello!   
      
   I just wonder if it's possible to have this DateTime.Today.AddYears(-14);   
   in a where statement of an sql select like this.   
      
   SelectCommand="SELECT OrderID, OrderDate, ShippedDate   
                              FROM Orders   
                              where CustomerID=@CustomerID   
                              and OrderDate >= DateTime.Today.AddYears(-14);"   
      
   I have tried but I get error so I don't think it's possible but just to be   
   sure I ask anyway.   
      
   //Tony   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)