Still having troubles With dates in SQL

[joopdog]

Thanks for your help earlier szlamany.

SQL is so crazy. You have to get it right on or it doesn't work.

How do I handle it the SQL date with a variable?

I'm still getting type mismatch.

  Dim dteDate As Date
      dteDate = "#08/13/2004#"
      'sql="SELECT * FROM DAILY_SALES_HIST_X WHERE DlvryDte=#8/13/2004#" 'IT WORKS!
      'sql="SELECT * FROM DAILY_SALES_HIST_X WHERE CustomerId='010110'"   'IT WORKS!
      sql="SELECT * FROM DAILY_SALES_HIST_X WHERE DlvryDte='dteDate'"

Help Please
Thanks

[si_the_geek]

For that (or any other kind of variable) you just need to do this:

sql="SELECT * FROM DAILY_SALES_HIST_X WHERE DlvryDte='" & dteDate & "'"

[szlamany]

SI - this is a bit of a double post - see this other thread...

http://www.vbforums.com/showthread.p...10#post2084210