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 |
|
kourvoisier
Starting Member
4 Posts |
 Posted - 2005-10-18 : 12:01:43
|
| Here is the situationIn Access i have a date field the data type is Date/Time and the format is short dateI am creating a ASP page that will grab every record that hasthe current date.I believe the problem occurs in the SQl statement.the date value that the sql query sends to access is in the wrong format and Access goes bonkers!!! cause it doesnt know what to do with it.Does anyone know what i can do to correct this.Anyone's help would be greatly appreciatedThanks in advance |
|
|
kourvoisier
Starting Member
4 Posts |
Posted - 2005-10-18 : 12:05:14
|
| Oh and the format is simple10/18/2005 -- is the format |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-18 : 12:41:56
|
| You need to give much more info. What statement are you sending? What does this have to do with SQL Server? What do you mean by "goes bonkers" ? You should not be adding dates using ANY specific format to a database; it should be done using parameters and date VALUES. |
|
|
|
|
|
|
date/time convert in SQL to Access in ASP