Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeats
Starting Member
6 Posts |
 Posted - 2001-01-10 : 23:51:26
|
| hi everyone,i'm having an issue with dates...i just need to know the correct syntax for specifying a date in a query (listed below)----------------------------------------------------------SELECT venues.venueName, gigs.actName, gigs.cost, gigs.dteDate, gigs.dteTime, gigs.gigID, gigs.description FROM venues INNER JOIN gigs ON venues.venueID = gigs.venueID WHERE (((gigs.dteDate)>=11/01/2001)) ORDER BY gigs.dteDate, venues.venueName; ----------------------------------------------------------this query returns ALL the records.i tried enclosing the date in #'s (access does it), but it only returns 2 records on my ASP (using an .mdb). however, if i run the query (with the #'s) in access, i get the correct result.i know this is a bit OT, but i couldn't find any other suitable forums...thanks in advance (hopefully) |
|
|
|
|
|
#date#