When entering the time object, enter it as a fully qualified date/time object rather
than just a time object. So instead of entering #CreateODBCTime(Now())# use
#CreateODBCDateTime(Now())#.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Eef Dekker [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 7:38 AM
> To: CF-Talk
> Subject: date/time format in Access
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0053_01C0270F.06A456C0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi-I am a beginner with beginner's questions. Here is a nagging one.
> Having set up an Access database with separate time and date columns, =
> every time I query it via a cfquery, I get the hidden date of the time =
> field back (30 Dec. 1899). I can of course do away with it by the =
> DatePart function, but if I then ask for a date match (e.g. , WHERE =
> Date=3D30-9-2000) somehow I then get no match.
> I have tried to input various formats first, like Date=3D9-30-00, =
> 9/30/2000, and the like, but this did not seem to do the trick, and I =
> was given the suggestion to put the dates in my table in ODBC format, =
> but this returned inapplicable, the database refused to take it. I used =
> the following code:
> <cfquery datasource=3D"kapper">
> INSERT INTO Afspraak(Datum)
> VALUES ('#CreateODBCDate (now())#')
> WHERE AfspraakID=3D1
> </cfquery>
> Who can help?
>
> ------=_NextPart_000_0053_01C0270F.06A456C0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> <HTML>
> <HEAD>
>
> <META content=3Dtext/html;charset=3Diso-8859-1 =
> http-equiv=3DContent-Type>
> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffe8a0>
> <DIV><FONT color=3D#000000 size=3D2>Hi-I am a beginner with beginner's =
> questions.=20
> Here is a nagging one.</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>Having set up an Access database =
> with separate=20
> time and date columns, every time I query it via a cfquery, I get the =
> hidden=20
> date of the time field back (30 Dec. 1899). I can of course do away with =
> it by=20
> the DatePart function, but if I then ask for a date match (e.g. , WHERE=20
> Date=3D30-9-2000) somehow I then get no match.</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>I have tried to input various =
> formats first,=20
> like Date=3D9-30-00, 9/30/2000, and the like, but this did not seem to =
> do the=20
> trick, and I was given the suggestion to put the dates in my table in =
> ODBC=20
> format, but this returned inapplicable, the database refused to take it. =
> I used=20
> the following code:</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2><cfquery=20
> datasource=3D"kapper"><BR>INSERT INTO =
> Afspraak(Datum)<BR>VALUES=20
> ('#CreateODBCDate (now())#')<BR>WHERE=20
> AfspraakID=3D1<BR></cfquery></FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>Who can =
> help?</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0053_01C0270F.06A456C0--
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
