Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
date in form ddmmyyyy needs simple valid/invalid test
I have three listboxes for a date - day,month and year. The day listbox has values 1-31 The Month listbox has values 1-12 The Year listbox has values 2005-2010 I concatonate these values and pass them to a database, so I have control over the format. This works fine until you select...- gsamm
- Thread
- Replies: 4
- Forum: Javascript
-
ASP MS Access Date in Where clause returns unexpected values
I am building a web site in ASP using MS Access as the database (for the time being) I excecute the following SQL query to retrieve records that are still 'open' (e.g the CloseDate must be in the future) SQL = "SELECT * FROM Project Where CloseDate > #" & Date() & "#;" This statement returns...- gsamm
- Thread
- Replies: 19
- Forum: Microsoft: ASP (Active Server Pages)
