expiration date issue

  • Thread starter access is making me crazy
  • Start date
A

access is making me crazy

I have a database that has dates that will all be in the 2000's. Is it
possible to have a date/time type only a two digit month and two digit year?
(mm/yy) I would like the day value to automatically be the last day of that
month, and the year would be "20yy" but for data entry reasons only have to
type in mm/yy.

Is this asking too much? Any input would be greatly appreciated.
 
K

Ken Snell \(MVP\)

The date/time field is actually a number, storing the number of days since
December 30, 1899 as the integer portion and the fraction of time since
midnight as the decimal portion.

To do what you seek, I recommend that you use two numeric fields -- one to
store the month, and one to store the year. Then you can "calculate" the
desired date in a query from those two values using the DateSerial function.

--

Ken Snell
<MS ACCESS MVP>


"access is making me crazy"
 
Top