Problem with Date changing

[Guest]

Hi I have a form that I manually imputting the dates on.

On is for the mm/yy.
The other is just a short date. When I add a new record my mm/yy it changes
the year from example 1/06 to 1/07. How do I stop this.
Thanks,
Keri

 

[Douglas J. Steele]

1/06 isn't a date. A date is a precise point in time. Access is taking your
input as 1/06 and assuming it's supposed to be the sixth day of January of
the current year.

If you're not supplying a complete date, you need to consider using a
different data type.

 

[Guest]

Keri,

If the format is mm/yy, it is not a date! Dates contain values for the year,
month, and day within the month.

Either store this info as a text value, or, more appropriatedly, store the
two fields separately as [SomeMonth], [SomeYear], and enter the numbers
independent of one another. Do not title these fields Month, and Year, since
these are Reserved words and may result in interpretation problems.

Dale

 

[Guest]

Ok if I input the whole date in how do I get it to just show the month and
year in the book Access 2003 bible said it was possible.

Keri,

If the format is mm/yy, it is not a date! Dates contain values for the year,
month, and day within the month.

Either store this info as a text value, or, more appropriatedly, store the
two fields separately as [SomeMonth], [SomeYear], and enter the numbers
independent of one another. Do not title these fields Month, and Year, since
these are Reserved words and may result in interpretation problems.

Dale
--
Email address is not valid.
Please reply to newsgroup only.

Hi I have a form that I manually imputting the dates on.

On is for the mm/yy.
The other is just a short date. When I add a new record my mm/yy it changes
the year from example 1/06 to 1/07. How do I stop this.
Thanks,
Keri

 

[Douglas J. Steele]

If you input the whole date, setting its format to mm/yy will display it as
01/06

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Ok if I input the whole date in how do I get it to just show the month and
year in the book Access 2003 bible said it was possible.

Keri,

If the format is mm/yy, it is not a date! Dates contain values for the
year,
month, and day within the month.

Either store this info as a text value, or, more appropriatedly, store
the
two fields separately as [SomeMonth], [SomeYear], and enter the numbers
independent of one another. Do not title these fields Month, and Year,
since
these are Reserved words and may result in interpretation problems.

Dale
--
Email address is not valid.
Please reply to newsgroup only.

Hi I have a form that I manually imputting the dates on.

On is for the mm/yy.
The other is just a short date. When I add a new record my mm/yy it
changes
the year from example 1/06 to 1/07. How do I stop this.
Thanks,
Keri