MSQuery Date parameter

[TheGus]

I have created a query using MSQuery and I want the user to be able to enter a start date and an end date so that a range can be created. However, no moatter what format I use for the date in the input box, I keep getting an error that the format is wrong!

Here is the part of the query that does this:

AND (ENDDT Between '#' & ? & '#' And '#' & ? & '#') AND

Any ideas why this is failing?

 

[mp9]

I haven't used MS Query in years, but shouldn't it be

AND (ENDDT Between #' & ? & '# And #' & ? & '#)
AND

?

http://www22.brinkster.com/accessory/

 

[TheGus]

That doesn't work either! I have tried every combination of the above but can get it to work.

Any other ideas

 

[PHV]

AND (ENDDT Between [Enter start date] And [Enter end date])

When prompted type the date like this: #1/15/2005#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

Slowed down by another lost connection ... sigh

Hmmm
The simple approach may to be to ask for each date separatly, test the date and then encapsulate for MS*Query

Dim StartDate as Date, EndDate as Date

StartDate = InputBox("Enter start date: ",,Date())

If IsDate(StartDate) then
  EndDate = InputBox("Enter start date: ",,Date())
  If Isdate(EndDate) Then
     ...AND (ENDDT Between "#" & StartDate & "#" And "#" & EndDate & "#") ...
  End If
End If

Richard