 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2005Inputting a date as Month - Year?
Is there any way a date field can be formatted so that the operator only has to enter month / year? (with preferably the day defaulting to the first day of the month)? I want to do in in such a way that the date format will be based on the PC settings. thanks in advance Simon Webb No, but you could store the month and year in two fields, and then use an expression to display the information on a form or report...no need to store a day if it's always going to be the first day. To display the date for the first day of a month/year combination: DateSerial([YearField], [MonthField], 1)  SignatureKen Snell <MS ACCESS MVP> > Is there any way a date field can be formatted so that the operator only > has to enter month / year? (with preferably the day defaulting to the [quoted text clipped - 6 lines] > > Simon Webb I think if you format your field as m/yyyy you'll get the effect you want. > Is there any way a date field can be formatted so that the operator only has > to enter month / year? (with preferably the day defaulting to the first day [quoted text clipped - 6 lines] > > Simon Webb As long as the user enters a full, 4-digit year, yes, this should work. SignatureKen Snell <MS ACCESS MVP> >I think if you format your field as m/yyyy you'll get the effect you want. > [quoted text clipped - 11 lines] >> >> Simon Webb What problem would you forsee if the user entered a month/2-digit year? Wouldn't this be interpreted, as requested by the OP, according to the PC's settings? > As long as the user enters a full, 4-digit year, yes, this should work. > [quoted text clipped - 13 lines] > >> > >> Simon Webb No, not per my testing. If for example, you enter 4/02 the value stored in the table is actually April 2, 2005 (for my US system). If you enter 3/98, the value stored is March 1, 1998; I assume the difference is because ACCESS knows that no month has 98 days. The confusion appears to result if the "second" number is 31 or less, obviously depending upon the month number for the "first" number SignatureKen Snell <MS ACCESS MVP> > What problem would you forsee if the user entered a month/2-digit year? > Wouldn't this be interpreted, as requested by the OP, according to the [quoted text clipped - 22 lines] >> >> >> >> Simon Webb I stand corrected. Apparently I hadn't tested enough. > No, not per my testing. If for example, you enter > 4/02 [quoted text clipped - 33 lines] > >> >> > >> >> Simon Webb |
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.