Short format November date problem

stratinblue · October 21st, 2006, 04:18 PM

I am having a problem getting a short format november date (e.g. 01/11/2006) to be passed in to an access 97 saved parameter query.

October dates work fine but not november dates.

Here is the asp code that passes the value in.

vardate=Request.Form("el")
Set rsEL = AdoCon.Execute ("exec qryweqrl #" & vardate & "#")

Is there a bug which allows the date 23/10/2006 but not 01/11/2006.

I have put in response.write vardate and 01/11/2006 appears.

Any suggestions will be gratefully received.

Thank you.

Steven · November 26th, 2006, 06:25 PM

Regardless of your Web server's locale, a date in Access must always be mm/dd/yyyy
Try this:

Code:

vardate=Request.Form("el")
Set rsEL = AdoCon.Execute ("exec qryweqrl #" & Month(vardate) &"/" & Day(varDate) & "/" & Year(varDate) & "#")

I am a loud man with a very large hat. This means I am in charge