passing date criteria in url parameter

[funkster-qv5H7D]

Hi,

I want to filter a recordset by a given date.
Create the recordset, if I use a runtime value of #27/11/06# all the records for that date are returned.
However, when I try to pass the same information through an URL Parameter it doesn't work.

Is there a problem with passing this info in that way?

Thanks, Mark.

[Newsgroup_User · Accepted solution]

No, should be absoloutely fine. The prob is most likely to do with your SQL
statement.

As a test, don't display any records. At the top of your page, try
outputting the completed SQL statement onto the page to see what it looks
like. The problem being you may need to add the # symbols manually. Should
look something like

"SELECT * FROM TableName WHERE DateField = #" & URLParameter & "#"

HTH,

Piers

[funkster-qv5H7D]

that worked first time

i had a hunch it was those pesky #'s but i'm a touch slow

thanks a million

mark