Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using only month and year for field (2000)

    I only want to have to record month and year in a series of fields. I formatted field to mm/yy and set up an input mask 00/00;*.

    The only problem is that if I enter 06/05 I get 05/05 and 04/06 I get 06/05? I have obviously missed something somewhere? I really don't care if say 01 was recorded as a day each time, but I don't want the people entering data have to worry about anything other than typing the correct month and year.

    I attach a small database with two date fields, formatted as explained above.
    Thanks
    Roberta

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: using only month and year for field (2000)

    You just can't do it that way - Windows interprets the input 04/03 as 4 March in the current year (if you're using UK date settings), i.e. as 04/03/05, and with date format mm/yy this is displayed as 03/05.
    You could use a combo box based on a table with dates such as 01/04/2005 in the first column, and text values such as April 2005 in the second column.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: using only month and year for field (2000)

    Yeah, trying to keep just month/year is a real pain. Here are just a couple of alternatives to Hans' suggestion. You could have 2 fields in your db, one for month and 1 for year. Or, you could use unbound textboxes for entry of month and year, then combine then (using a standard "1" for day) to create the date field in your db. You just have to figure out which is best for you situation.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •