All of a sudden, my date fields are showing a datetime with the time
****tion
the same in every table and database I open.
The time ****tion is 12:17:04 AM regardless of what table or database I
open.
If I run a query on a date field and convert it to a double format,
"cdbl([the date])", the number has no decimal ****tion!
The date is stored as a whole number.
If I enter a date in a datetime field the time is automatically appended
to
the
date in the display but the time ****tion is not stored in the data file.
I am able to open the same mdb's on another computer, and there is no
problem with the date fields.
I have played with changing my system Regional Setting and problem still
exhists.
The only thing I was able to do is go into a database table design mode
and
add shortdate to the format of each date field.
This fix is tem****ary because I do not want to have to change 100+ mdb's.
One strange thing I came across was: If I open a query view and enter
Expr1:CStr(#12/11/2002#)
then exit the field, the system automatically changes my
entry to Expr1: CStr(#12/11/2002 12:17:04 AM#).
This anomaly is being created by the OS or Access somehow!
Any suggestions will be greatfully appreciated.
