 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2005Date Input Mask
I want to enter a date like 12/04. The imput mask gives me everything but this. How do I set the Input for just a two digit month/year? Thanks! >I want to enter a date like 12/04. The imput mask gives me everything but >this. How do I set the Input for just a two digit month/year? >Thanks! You don't. An Access Date/Time value is actually stored as a double float number, a count of days and fractions of a day (times) since midnight December 30, 1899. As such, any date/time value must correspond to a precise instant of time. December 2004 was not an instant (it was a *long* time for me... <g>) I'd suggest either using two Integer fields, not named Month or Year (reserved words) but something like ExpMo and ExpYr, and concatenate them for display; or use a Text field. John W. Vinson[MVP] I appreciate your reply, although it was quite confusing. I entered an input mask of 99/99 and received exactly what I wanted. Thanks! > >I want to enter a date like 12/04. The imput mask gives me everything but > >this. How do I set the Input for just a two digit month/year? [quoted text clipped - 11 lines] > > John W. Vinson[MVP] =?Utf-8?B?U2Ft?= <Sam@discussions.microsoft.com> wrote in news:DA38DB75- 054A-47B2-8A93-3C82FF1215F5@microsoft.com: > I entered an input > mask of 99/99 and received exactly what I wanted. You would be well advised to re-read John's reply. An input mask like this will let you enter a value of "12/04" but be advised that this will be stored as April 12th, 2005 -- which may or may not be what you want! All the best Tim F |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.