|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 10th, 2004, 12:50 PM
|
|||
|
|||
|
SQL where ??=date
Hello...
I have this program that is trying to select from a MS Access table where a date = cdate(string in date format) and every time it retireves nothing... I'm thinking it's a format issue... Any Ideas...
|
|
#2
April 26th, 2004, 02:20 AM
|
|||
|
|||
|
I was trying to do the same thing in C++ using a DAO recordset and ran into the same problem.
I ended up needing to surround my date value with "#" Example: my where string was "StartDate = #04/05/2004#" Hope this helps.
|
|
| Viewing: ASP Free Forums > Database > SQL Development > SQL where ??=date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
