Re: Help with ACCESS and DATES.. Oh The Horror!!

2003-08-04 Thread Jeff - Development
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 > >

Re: Help with ACCESS and DATES.. Oh The Horror!!

2003-08-04 Thread Bud
>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

Re: Help with ACCESS and DATES.. Oh The Horror!!

2003-08-04 Thread dwayne
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

Re: Help with ACCESS and DATES.. Oh The Horror!!

2003-08-04 Thread Dave Lyons
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 > > >

Help with ACCESS and DATES.. Oh The Horror!!

2003-08-04 Thread Jeff - Development
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