Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. 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 Databases 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
Old March 29th, 2005, 12:30 PM
Authorized User
Join Date: Jul 2004
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Default putting a date into a date field

This might be a simple question - but I was wondering what is the best way of having the user enter a date via a form and then putting it in a date field - should I have three seperate drop down boxes for day month a year? if so what format should they be in (should the month be 01,02 or jan, feb....and what about the year 00,01,01 or 2000,2001,2002...) and then how do I put it together to go into one date field....Thank you

Old March 30th, 2005, 02:07 AM
Authorized User
Join Date: Dec 2004
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to shankhan Send a message via Yahoo to shankhan

i'm also using three drop down menus for date and the best format which is most friendly for user is date in 01, 02 ... 31 month in Jan, Feb ... Dec and year in 2001, 2002 .... 2010 format.

Old March 31st, 2005, 01:30 PM
Registered User
Join Date: Mar 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts

I suppose it all depends if you need it in a very specific format or not.

If your database REQUIRES that the date look like: 09/02/1978, Then you should do drop downs because you can then specify the format in the selected values.

If you DONT need a specific format, I use one box where a person can hand enter a date. When the form field loses focus, I have a javascript run a check to ensure that what they entered is a valid (albeit not STRICTLY formatted) date.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating a Date field based on another field arholly Access VBA 6 November 22nd, 2006 11:19 AM
date field keyvanjan Classic ASP Databases 1 May 7th, 2005 02:32 AM
Date Field from Parameter Field narooma.12 Crystal Reports 0 November 14th, 2004 08:51 PM
DTS Import ( Date string to Date field) gfowajuh SQL Server 2000 1 September 30th, 2003 06:28 AM
Date Field costrega Classic ASP Databases 2 September 16th, 2003 02:46 PM

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