quot;CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 04, 2003 4:38 AM
Subject: Help with ACCESS and DATES.. Oh The Horror!!
> I've got a strange one, its pretty strange to me, maybe not to one of
you...
>
> I insert a date for a record using this set statement
>
>
>I've got a strange one, its pretty strange to me, maybe not to one of you...
>
>I insert a date for a record using this set statement
>
>
>and inside the database the record looks like this
>
>8/1/2003 2:47:29 AM
CreateODBCDate(now()) would not put that time in the database.
CreateODBCDate(n
Jeff you might want to consider storing only the "date" in your your record_modified
field and then create another field to store the time. When you add both the time and
date to the same field, I think you violate one of the rules of database
Normalization.
Dwayne Cole, MS in MIS, MBA
Flor
CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 04, 2003 4:38 AM
Subject: Help with ACCESS and DATES.. Oh The Horror!!
> I've got a strange one, its pretty strange to me, maybe not to one of
you...
>
> I insert a date for a record using this set statement
>
>
>
I've got a strange one, its pretty strange to me, maybe not to one of you...
I insert a date for a record using this set statement
and inside the database the record looks like this
8/1/2003 2:47:29 AM
There are about 12 entries on this particular date, various times. Easy
enough. Now I go
5 matches
Mail list logo