Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates in a SQL Statement
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates in a SQL Statement
I would use the following:
strSQL = "SELECT * FROM tblMain WHERE [fldDateFrom] = '" & Format(dateFrom,"yyyy-mm-dd") & "'" On 30 May, 15:40, NateBuckley wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement for Dates | Excel Worksheet Functions | |||
IF Statement Using Dates | Excel Discussion (Misc queries) | |||
IF Statement with Dates. | Excel Programming | |||
If statement with dates | New Users to Excel | |||
IF statement with two dates | Excel Discussion (Misc queries) |