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

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
 
W

Wayne Morgan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display of Null date vs. 12/30/1899 2
DATES PRIOR TO 1900- 12/30/1899 in particular 2
avoiding 31/12/1899 with empty dates 9
Use 12/30/1899 in access 2007 2
30/12/1899 Error when importing Time from Excel to Access 3
cannot format 12/30/1899 or 12:00:00 AM 1
Additional value is added to date value or time value after exportingaccess data to text format 2
Date Defaulting in Data Field 3

Top