SQL Server Char/VarChar DateTime Error
Can someone tell me why this code produces error?

The C# code

    DateTime now = DateTime.Now;
    DateTime after1month = DateTime.Now.AddMonths(1);

The query it produce

    SELECT * FROM TABLE WHERE THEDATE BETWEEN 'now' AND 'after1month' 

Any help is appreciated.
Thx
SQL Server Char/VarChar DateTime Error
===

Can someone tell me why this code produces error?

The C# code

    DateTime now = DateTime.Now;
    DateTime after1month = DateTime.Now.AddMonths(1);

The query it produce

    SELECT * FROM TABLE WHERE THEDATE BETWEEN 'now' AND 'after1month' 

Any help is appreciated.
Thx