Linked to table/view in SQl server (1 Viewer)

[aftershokk]

We have an Access DB linked to a view in SQL Sever 2005. The date in the view is formatted as 2006-09-08 00:00:00.000

I want the user to be able to use a parameter in Access to select records based on date ranges using the between statement. I have tried a bunch of different ways but nothing has worked.

any ideas?

thanks!

 

[Galaxiom]

It looks to me that a Between condition should work on the strings since the date is expressed in most significant digits order.

Recommend you use a date type textbox controls rather than parameters in Access (unless you mean parameters sent to SQL Server).

User enters the date in the local format.

Convert the Access date to the same format as the SQL Server:
Format([somedate], "YYYY\-MM\-DD HH\:NN\:SS")