Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Western Australia
    Posts
    4

    Exclamation Unanswered: date fields in tables

    I have a date field in a table. want to only enter months and years into it, and let it default to the first day of the month for each record. Tried putting input mask on the table - something along the lines of:
    00/0000;0;#
    When I enter data into the table directly like this, anything below '30' for year enters either the year as the day, or the month as the day and the year as the month (then defaulting the year to the current year, 2004).

    What I'm ultimately doing is creating Data Access Pages to access the database, so I'm not sure of any input masking or restricting of data entry I'll be able to do with those yet.

    Any suggestions?

    Thanks.

  2. #2
    Join Date
    Dec 2003
    Posts
    268

    Format

    Set the format to mm/yyyy

    Then the users can enter in any date they want, but what will be stored in the table is only the month and the year.

Posting Permissions

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