Changing an unput mask

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?

On Mon, 29 Dec 2008 11:02:02 -0800, Reen (donotspam)
wrote:

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?

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.

--

John W. Vinson [MVP]

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


"Reen" (donotspam) wrote in message
...
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?