Creating a List Array for use in an ADO query

[mferrisi]

I am trying to run a query that returns the data only on certain dates. I've done it this way before with strings (ie to return string values from the datadase) but it doesn't seem to like the string with dates that I create. Am I missing something?

My error message is:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

I don't think there is an Array List in VBA?

[VBA]
t = SDate & ", " & FDate & ", " & EDate

cmd.CommandText = "SELECT hist_date, hist_price " & _
"FROM history " & _
"WHERE (name='TheName') AND (type='accounting') " & _
AND (date ='" & t & "')"
[/VBA]

[mvidas]

What about something like [vba]cmd.CommandText = "SELECT hist_date, hist_price " & _
"FROM history " & _
"WHERE name='TheName' AND type='accounting' " & _
"AND (date = " & SDate & " OR date = " & FDate & " OR date = " & EDate & ")"[/vba]

[mferrisi]

The problem though is that I might be querying from 100's of dates, which was why I was hoping to do something a bit more compact

[Bob Phillips]

Surely, if there are hundreds of dates, it woulkd be more practical to write them to a database table, and then use that table in the query.