You probably need to surround the datetime value in quotes:
DataRow[] drSelected = dsMyTableAllrecords.Tables[0].Select("red ='"+DateTime.Now+"'" );
otherwise your are passing an numerical operation (e.g. 2004/12/10 is treated as 2004 divided by 12 divided by 10)
>Hello all,
>
>I am trying to get an array of DataRows by setting a filter based on a DateTime condition. But I keep getting an error.
>
>Here is the code :
>
>
>DataRow[] drSelected = dsMyTableAllrecords.Tables[0].Select("red ="+DateTime.Now );
>
>
>Here is the error:
>
>Missing operand after '2' operator.
>
>
>Any idea??.
>
>Sergio
Hector Correa