The best way to store the data is in a date formated column. Otherwise,
later on when you goto perform a datediff statement you will need to convert
all of the data from the columns and there is no real way at that point to
ensure the data will not create and error if the conversion does not go
well, happens really often!!!.
Chris Williams
-----Original Message-----
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 27, 2000 3:54 PM
To: CF-Talk
Subject: RE: DateTime Stamp Problem
I'm not going to answer the question about the best way to store your data.
But can we see the original query?
--K
-----Original Message-----
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 27, 2000 3:10 PM
To: CF-Talk
Subject: DateTime Stamp Problem
I have a access database and I can't get the value of ,
'#CreateODBCDateTime(Now())#', in my Insert statement to work. I get the
error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression ''{ts '2000-10-27 14:49:50'}''.
The field type is text and a length of 100.
Is this the best way because long term I will search DateDiff of these
fields...
Any help?
-Chris
www.chris.com
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
