Hi all,
I have a problem on using a auto date field, for example

Field1 :caseNo.
Field2 : dateEntered ( this is an auto date field, which i put Now() on default )

a weird problem happen is if i insert data through application, this date will go beyond now() time,

for example

record1: case_1 06/16/06 5:26:44 PM
record2: case_2 06/16/06 5:54:16 PM

then the next new record which havent add in, i can c the default value which is 06/16/06 5:34:12 PM

and the time now in fact is 06/16/06 5:34:12 PM

what the hell is going on? how does record2 come in and the time is future time?

Anyone know?