Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
| Search | Today's Posts | Mark Forums Read
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 21st, 2006, 04:18 PM
Registered User
Join Date: Oct 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Short format November date problem

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.

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.
  #2 (permalink)  
Old November 26th, 2006, 06:25 PM
Friend of Wrox
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

Regardless of your Web server's locale, a date in Access must always be mm/dd/yyyy
Try this:
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting short date to show mm/dd/yyyy crabjoe Access 4 March 7th, 2007 03:46 AM
Date Format Problem Scripts82 Access VBA 2 March 13th, 2006 09:36 PM
Date format problem ERC Crystal Reports 1 June 15th, 2005 04:03 AM
want to get short date noor ASP.NET 1.0 and 1.1 Basics 3 May 8th, 2005 01:24 AM
Date format problem widad Classic ASP Basics 1 October 15th, 2004 06:31 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.