Re: problem with short date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The view of the date field isn't as important as the how we can enter the
information. (ex 010109 shows as 01/01/2009 or 01/01/09). But when I add the
command button to duplicate the record, after it copies the record, I get an
error "The value you entered isn't appropriate for the input mask
'99/99/99;0;_' specified for this field."

"Douglas J. Steele" wrote:

Why do you want it to display only a two-digit year?

You say you want to add a "Duplicate record" command but you get an error
with it. What's the code you're trying to use?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"rjejyork" <rjejyork@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EA24D428-7EF1-4006-8FA0-0C06B67C621B@xxxxxxxxxxxxxxxx
Thanks Doug,
Any suggestions on a work around? Also, I am using the date fields to
calculate the number of days between two dates.

"Douglas J. Steele" wrote:

Sorry, but as long as you're using a Date data type, you really have no
choice here. That's because under the covers, the Date data type is an
eight-byte floating point number, where the integer portion represenst
the
date as the number of days relative to 30 Dec, 1899 (and the decimal
portion
represents the time as a fraction of a day). In other words, Access must
know the exact year in order to store the date properly.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"rjejyork" <rjejyork@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CD2D4AB4-715B-4F0C-B78C-083A0AFB6D6F@xxxxxxxxxxxxxxxx
I am using the short date input mask in my field. But when it shows the
date, it changes the way i want it to look. When entering a date, I
want
to
be able to simly type 010109 and have it show as 01/01/09. I edited
the
input mask to allow this, and it works, but when I tab off the field,
it
changes it to 01/01/2009. I want it to stay just as I typed it. I
want
to
add a "Duplicate record" command but when I try to do it, I get an
error
with
respect to the date field and I think it is because it is changing the
value
from what I typed to showing all four digits of the year and it won't
let
me
copy the record. Any suggestions?
Thanks
Rachel






.

Quantcast