Changing an unput mask

R

Reen

I want to change the way a date is entered in my database from MM/DD/YYYY to
MM/YY, how am I supposed to do that?
 
J

John W. Vinson

I want to change the way a date is entered in my database from MM/DD/YYYY to
MM/YY, how am I supposed to do that?
Click to expand...

A Date/TIme field is always a precise point in time. You can *display* a date
to show only the month and day, but it's still stored as a Double Float count
of days and fractions of a day since an arbitrary start point.
 
J

Jeff Boyce

As John points out, you can store your date, but choose to format the
display (in a form, in a report) however you'd like, including "MM/YY".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top