SQL parameter query

S

smk23

I have a pass through to SQL that I need to pass a parameter to.

WHERE (((v.DateDiagnosis)>= '?' And (v.DateDiagnosis)< '?')

Doesn't work. What is the correct syntax?

Thanks!!
 
O

oozyscab via AccessMonster.com

If your query is hitting against Oracle then the parameter date needs to be
in a specific string format. The format is 'DD MMM YYYY'.

So it should look something like this...

WHERE (((v.DateDiagnosis)>= '01 OCT 2005' And (v.DateDiagnosis)< '01 NOV
2005')
 
Top