Problem passing values to Query

[therayster]

I have a form with two DTpicker controls. The user will use these to select a start and end date for a query, then click a button and presto! ...up comes the report for that time period. However due to some stuff we do with the timestamps on the records I need to take the date entered and adjust it for the user to get results that actually reflect the timeframe they're querying for. So in my query's criteria field I have:

Between (DateValue([Forms]![Interface]![startdate])-0.00069)
And (DateValue([Forms]![Interface]![enddate])+1.00069)

However when i try to run the query with this criteria I get a "OBDC call - Failed" message. If I remove the values after the dates it runs. Does anyone know why, and if so how do I make it work?

 

[Aivars]

Between #" & DateValue([Forms]![Interface]![startdate])-0.00069 & "# And #" & DateValue([Forms]![Interface]![enddate])+1.00069 & "#"

Aivars