Excel VBA Question: Return if Between 2 Dates

[S_W_Langdon]

Hi Everyone,

I have had a scan (search) through the posts but am unable to find something on this, so sorry if I missed it, or searched wrong...

I have an Access Database and am trying to pull information out of it into excel based on 2 dates within cells, now I can get it to pull the information from the Database, but it isn't pulling it correctly, instead of pulling all data between the 2 dates it is pulling everything (before, after, between)

Here is the code that I have setup (Var & Var1 are the reference cells)

If Sheet2.Range("AL2").Value = "Yes" Then
SQL = "SELECT * FROM DatabaseTable WHERE StatusStartDate < #" & var1 & "#Then"
SQL = "SELECT * FROM DatabaseTable WHERE StatusStartDate >= #" & var & "#"
Else
SQL = "SELECT * FROM DatabaseTable WHERE StatusStartDate LIKE '" & var & "%" & "'"
End If

I have tried changing the <> on different rows to see if that helps, but it isn't working (am more used to Excel Formula I am afraid)

Any help people can give would be great

Thanks

 

[S_W_Langdon]

Hi again everyone,

I had a random thought and it worked, ended up being a very simple fix in the end, please see code below

If Sheet2.Range("AL2").Value = "Yes" Then
SQL = "SELECT * FROM DatabaseTable WHERE StatusStartDate BETWEEN #" & var & "# AND #" & var1 & "#"
Else
SQL = "SELECT * FROM DatabaseTable WHERE StatusStartDate LIKE '" & var & "%" & "'"
End If

Just need to get my head out of Excel Formula and back to VBA/ SQL since it has been years

Anyway, hope that this helps someone else in the future