expiration date issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 

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

Input Mask and Adding Century Prefix for Year 2
Excel Vba to change displayed year automatically. 14
Input Mask for Dates and field's end result 1
Date format automatically changed 1
Access 2 Digit year in Access Text Box 3
Manage MM/YY date 1
Automatic input mask.. 1
Using dateserial to convert text string to dates 7

Back
Top