Hey everyone,

I'm trying to use the Go To Detail Page server behavior to pass a Date/Time URL Parameter to my detail page.

I've setup the detail page to filter the recordset based on the URL parameter the main page passes to it.

Whenever I try the link, I get a data mismatch error.

Do I need to convert the Date/Time parameter to something else (integer, string, etc)? Can I even pass a Date/Time URL Parameter, or can it only be an integer?

I have a feeling that the spaces in the Date/Time field are screwing this up.

Any thoughts?

Edited by - kratz on 23 May 2003 06:27:07

Date / Time params can always be a pain. You can send them as url params but you have to make sure that the format is correct against what is held in your db.

Can you give me an example of:

1. What the date looks like in the url.
2. what type of database you are using.
3. what the field type is
4. what region you are in (US, UK, Europe etc)



Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting