Date Problem - Page 2

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
Date Problem

Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics 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

Page 2 of 2

August 13th, 2004, 01:43 PM

happygv

Friend of Wrox

Join Date: Jun 2003

Posts: 2,480

Thanks: 0

Thanked 1 Time in 1 Post

Yes Tim,

MSSQL needs date to be wrapped around with single quotes and Access always requires # around the date values when used in SQL statements. As Rod suggested, it is always good to stick with yyyy/mm/dd formats for the dates, to be out of such date format problems.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Page 2 of 2

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DATE PROBLEM	ricespn	Classic ASP Basics	3	October 20th, 2006 07:15 AM
Date Problem	kuku	SQL Server 2000	4	September 7th, 2005 08:38 PM
Date Problem.	rupen	Classic ASP Basics	3	June 3rd, 2005 09:58 AM
date problem	hosefo81	PHP How-To	2	May 26th, 2004 11:12 AM
Date problem	Larson	VB How-To	2	December 30th, 2003 06:10 PM