Where clause with date type. Need help

compvis

hi,

I have a table with a field that has data type is date. So how can i filter data in table by date type, like:

TableMappings mappings = new TableMappings();
sourcedb.Register(sourcecn, Options.Default);
targetdb.Register(targetcn, Options.Default);
mappings.CreateMappings(sourcedb.Tables, targetdb.Tables);

foreach(TableMapping tbm in mappings)
{
    if (tbm.Obj1.Name == "DQP_T3") 
    {
           tbm.Include = true;
           tbm.Where = new RedGate.SQLDataCompare.Engine.WhereClause("Date >= 10/10/2000 && Date <= 10/10/2011");
     }
     else
     {
           tbm.Include = false;
     }
}

Thanks

James B

That looks reasonable, except as it's a SQL clause, you need to use AND rather than && - for instance:

tbm.Where = new RedGate.SQLDataCompare.Engine.WhereClause("Date >= 10/10/2000 AND Date <= 10/10/2011");

Does that help? Also, to avoid any potential confusion over date formats you may want to specify the dates as yyyy-mm-dd.