12/30/1899 or 12:00:00am now

  • Thread starter Thread starter nope
  • Start date Start date
N

nope

Access97 linked to FoxPro database now I am into Access2003 using OBDC
..
With 97 I used to get empty cells in a LASTSALE field now they show as
12:00:00AM or if I set formatting for the query field as short date I
get 12/30/1899 do I actually have to make an expression for this? I
can do that but I have 8 different date fields and liked the way it
worked in 97.

These don't appear to be null but rather 0 values or something. Why is
this changed? Is there something I haven't setup the same?
Thanks anyone for explaining
 
There is a difference in the way Access 2003 and 97 set some of the
defaults, particularly in Allow Zero Length. These articles may help. Due to
the way VBA/Access handles dates, what you are seeing is the value for zero.
Dates are stored as an offset from the date you are seeing. The whole number
portion is the number of days from this base date and the decimal portion is
the time (fraction of a day).

These are for Access 2002, but apply to 2003 as well.

http://support.microsoft.com/?kbid=287490
http://support.microsoft.com/?kbid=837147
 
Back
Top