Date 09/07/2004=12/30/1899

B

Bonnie

Hi everyone! Using A02 on XP. Have a form with a subform
showing if a bill was sent and when. Field is
[InstallBill]. I have a field on my form that is named
InstBill and =[NewBusSub].[InstallBill]. Both are
formatted to Short Date but when I click my button to
carry the date into my main form field
[InstallationBillSentDate], it appears as 12/30/1899. Can
anyone shed any light on this?

Thanks in advance for any help or advice.
 
K

Ken Snell [MVP]

A date/time value always includes both a date and a time portion. This is
because the date/time value is a double precision decimal, where the integer
portion is the number of days since December 30, 1899, and the fraction
(decimal) portioin is the time in fractions of 24 hours (e.g., 0.25 = 6 AM
and 0.5 = 12 noon). If the value is just a date only, then the time portion
is zero. If the value is just a time only, the integer portion is zero.

A value of zero for the integer portion means a date of December 30, 1899,
which is what you're seeing. Thus, I would guess that your form is not
correctly reading the value that you intend.
 

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

Access 2003-Date() = 12/30/1899 not 06/15/2009 why? 3
12/30/1899 saved in table instead of user input 3
If SubForm HasNoData 3
Problems with Date fields 1
30/12/1899 Error when importing Time from Excel to Access 3
DATES PRIOR TO 1900- 12/30/1899 in particular 2
Recording the Date and Time When a Record is Modified in Access 6
Display of Null date vs. 12/30/1899 2

Top