Adding 2005 Date to "Month/Year" Table field

[Rudi Samoszynski]

I need to begin adding next year's data into one of our
Access'97 databases.

The format is mmmyy; the input mask is LLL/00; Field is
Date/Time.

Date such as Sep04 goes in OK. But Feb05 will not go in.
In fact ir will change the year to 04???

Can anyone assist please.

Thanks and regards

Rudi S.

 

[Douglas J. Steele]

Date/Time fields must be complete dates: partial dates such as mmmyy are not
sufficient. That's because under the covers, the value is stored as an 8
byte floating point number, where the integral part represents the date as
the number of days relative to 30 Dec, 1899, and the decimal part represents
the time as a fraction of a day. I think you'll find that your Sep04 is
actually being stored as 04 Sep, 2004, and that Feb 05 is being stored as 05
Feb, 2004.

One solution is to store the values as text.