Dates in a SQL Statement

N

NateBuckley

Hello,

I'm using ADODB to connect to an ACCESS database I've set up. I have a few
fields that are Date types and I send the SQL statement via a string, the
thing is I'm getting errors when trying to use Variables that are dates in
the string.

My SQL Statement

strSQL = "SELECT * FROM tblMain WHERE [fldDateFrom] = '" & dateFrom & "'"

it'll turn my variable dateFrom into just a string. So doesn't match up when
it comes to putting this value into the database.

Anyway to make sure this gets put in as a Date type?

Sorry If that's unclear.

Nate
 
A

Andrew Taylor

I would use the following:
strSQL = "SELECT * FROM tblMain WHERE [fldDateFrom] = '" &
Format(dateFrom,"yyyy-mm-dd") & "'"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the amount of days between two dates. 3
VBA - A Problem with Dates. 2
Can't create recordset to populate userform combobox 3
change date in a sql statement from a cell 1
Change Form's Recordsource with SQL Statement? 0
VBA Excel data to SQL Sever table 1
SQL statement not working 2
Passing dates to Sql Server 2005 stored procedure 3

Top