-
From: Rajput, Goutam [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 12:29 PM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: date problems in conversion from Access to SQL
Like I said change the datatype to datetime or use cast or convert functions
for DOB fields.
Also Datevalue is not
I have an emergency conversion from an Access database to SQL.
Even in an emergency, you may have to do this in two stages.
Assuming that you can't use the original table, then I would:
1. process the existing table by picking up the string that represents your
date and using VBScript to build
:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:10 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: date problems in conversion from Access to SQL
String. I tried using DateValue to convert the field (as shown below), but
I get the error described below
-Original Message-
From: Rajput
String. I tried using DateValue to convert the field (as shown below), but
I get the error described below
-Original Message-
From: Rajput, Goutam [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:19 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: date problems in conversion from
What is the data type for [DATE OF BIRTH] field?
Try this use cast or convert functions to convert [DATE OF BIRTH] field.
-Original Message-
From: Diane Schips [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 9:49 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] date problems in conversi