R Reen Dec 29, 2008 #1 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?
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 Dec 29, 2008 #2 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.
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 Dec 29, 2008 #3 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
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
