Troubleshooting - Getting Unexpected extra token error in Date Field Query

Problem Description:

I am trying to query the Transaction table based on the TxnDate field.

I tried the below code.

OdbcCommand SourceCmd = new OdbcCommand("Select * from Transaction where TxnDate >= {d '2010-01-01'} and TxnDate <= {d '" + DateTime.Now.ToString("yyyy-MM-dd") + "'} ", cnQODBC);

I am getting this error:

ERROR [42000] [QODBC] [sql syntax error] Expected lexical element not found: =

And when I try this one:

OdbcCommand SourceCmd = new OdbcCommand("Select * from Transaction where TxnDate >= #2010-01-01# and TxnDate <= #" + DateTime.Now.ToString("yyyy-MM-dd") + "# ", cnQODBC);

I get this error:

ERROR [42000] [QODBC] Unexpected extra token: #

What is the correct format to pass the date values ??

I am using C#.

Solution:

Please refer to the below-mentioned article for the date format in QODBC:
How are dates formatted in SQL queries when using the QuickBooks-generated timestamps