How do you modify a date format to accept no day entry?

D

Dianne

I am trying to modify the short date format so that it will accept entries
where portions of the date is unknown. For example, I want the field to
accept 01/00/2001 as an entry. The current format requires that 1-31 is
entered as a day.
 
S

Steve Schapel

Dianne,

If this is a Date/Time data type field, then the data entered must be a
valid date value, there is no way around that.

You could enter your date with an arbitrary day, for example the first
or the last of the month, if the day doesn't matter, and then format the
display of this so the day is not shown, for example Jan 2001 or
whatever you like.

Another option, I suppose, is to use a text data type instead... but
then you won't get it to behave like a date.

Maybe if you could say something more about what you are trying to
achieve, and someone may be able to advise further.
 
Top