to enter month and year only

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

A Date field must be a complete date. This is because under the covers, it's
stored as an 8 byte floating point number, where the integer part represents
the date as the number of days relative to 30 Dec, 1899, and the decimal
part represents the time as a fraction of a day.

You must either use a text field, or separate fields for year and month, or
decide on a default day (say the first of the month) if you're going to use
a date field.
 
Possibilities:

1) Have them enter an entire date but state on the form that only month
and year will be used.
2) Two numeric fields but you then have to edit at least the month to
make sure it is between 1 and 12 AND you will have to either edit or
tell how they are to enter year (2006, or 006 or 06 and you will
supply the 2000 part of it. Watch out if they have to go back to 1995 -
prior century.

Ron
 
I need to construct a table or a form that allows only entering a month and
year only. How can I do this? E.g I just need to enter "june 05".

Will my my field type a date? or any suggestions apart from text type field?
 
Back
Top