Changing an unput mask Reen 12/29/2008 7:02:02 PM 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?

Re: Changing an unput mask John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/29/2008 7:26:58 PM On Mon, 29 Dec 2008 11:02:02 -0800, Reen <Reen1176[ at ]hotmail.com(donotspam)> wrote: [Quoted Text] >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]

Re: Changing an unput mask "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/29/2008 8:53:33 PM 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" <Reen1176[ at ]hotmail.com(donotspam)> wrote in message news:EEA9F3B3-16A2-4903-8125-8DF8885013A9[ at ]microsoft.com... [Quoted Text] >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?