SQL Compare Date field to today

[Kurt111780]

I'm trying to query an access database using C# and ASP.Net. I need to compare the access date field with the current date. This is what I came up with but it does not work.

DateTime dteDate = DateTime.Now;

//query database
objCmd = new OleDbCommand ("SELECT * FROM exhibitions WHERE dteEndDate = " + dteDate + " ORDER BY dteEndDate", objConn);

This is the error message:

Syntax error (missing operator) in query expression 'dteEndDate = 2/18/2005 12:45:44 PM'.

How can I compare a date to todays date?

Thanks,
Kurt

 

[ca8msm]

I haven't used access for a while but I think it needs a # sign either side of the date.

Also rather than using DateTime.Now use DateTime.Today.ToShortDateString as you don't want to include the time. e.g.

String strDate = DateTime.Today;

objCmd = new OleDbCommand ("SELECT * FROM MYTABLE WHERE MYDATE = #" & strDate &  "#", objConn);

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.