ado sql date search syntax help 1

[DK47]

I need some help with the syntax required to return data between user specified dates.
txtFrom and txtTo are user input text boxes where only date formats are allowed.


adoChart.RecordSource = "SELECT * FROM History WHERE (Date) BETWEEN ' & txtFrom & ' AND ' & txtTo & ' AND Investor_Number = " & frmStartPage.txtHoldInvestorNumber & " Order By Date DESC"
adoChart.Refresh


Thanks,
Dwight

 

[zarkon4]

Try this

adoChart.RecordSource = "SELECT * FROM History WHERE (Date) BETWEEN ' & CDate(txtFrom) & ' AND ' & CDate(txtTo) & ' AND Investor_Number = " & frmStartPage.txtHoldInvestorNumber & " Order By Date DESC"

OR

adoChart.RecordSource = &quot;SELECT * FROM History WHERE (Date) => '&quot; & CDate(txtFrom) & &quot;' AND (Date)=<'&quot; & CDate(txtTo) & &quot;' AND Investor_Number = &quot; & frmStartPage.txtHoldInvestorNumber & &quot; Order By Date DESC&quot;

 

[DK47]

zarkon4,
Thank you very much for your time and your help.
Much appreciated!
Regards,
Dwight



I tried this with single quotes (') and double quotes (&quot as shown below and I still get sytax error (Missing operator)
Any other ideas?

adoChart.RecordSource = &quot;SELECT * FROM History WHERE (Date) BETWEEN &quot; & CDate(txtFrom) & &quot; AND &quot; & CDate(txtTo) & &quot; AND Investor_Number = &quot; & frmStartPage.txtHoldInvestorNumber & &quot; Order By Date DESC&quot;


I'll try your second example next.
DK

 

[zarkon4]

Make sure the quotes are correct

adoChart.RecordSource = &quot;SELECT * FROM History WHERE (Date) BETWEEN ' &quot; & CDate(txtFrom) & &quot; ' AND ' &quot; & CDate(txtTo) & &quot; ' AND Investor_Number = &quot; & frmStartPage.txtHoldInvestorNumber & &quot; Order By Date DESC&quot;

remove the spaces between the single and double quotes

 

[DK47]

Thanks, I'll give it a try.
DK

 

[johnwm]

Shouldn't (Date) read [Date]?

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[Jimgarry]

Try this #

strsql = &quot;Select * from timedata where weekending BETWEEN #&quot; & datBegDate & &quot;# AND #&quot; & datEndDate & &quot;#&quot;

 

[DK47]

Jim and John,
Thanks guys.
DK

 

[DK47]

Jimgary,
Thanks buddy, your's did the trick.
Have great weekend.

Here's a star!

Regards,
Dwight

 

[johnwm]

It would have been a lot easier if we had known that you were using a Jet db!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[DK47]

Sorry about that,
I'll be more detailed the next time.
Regards,
Dwight

PS
By the way I needed that bit of code to grab data for an MSChart control, and it works great.
Can't thank you guys enough for taking the time to help.
DK