Enter date without slashes

[zSplash]

I want to enter dates without slashes (i.e., 051907, or mmddyy), but am
unable to define an input mask for dates without slashes. Do I have to
identify the input mask as a string, and then take whatever the entry is and
convert it to a date, or what's the deal?

TIA.

 

[Wayne-I-M]

Hi
Set the format on the form as
mmddyy

If the field in the table is formated as a date/time field the format on the
form will not affect what is stored just what you see (and input) on the form.

012507
will be stored as
25th Jan 2007

Hope this helps

 

[Wayne-I-M]

ooops sorry for that Joseph I have should have pointed that out

 

[zSplash]

Thanks, guys, for the help, but when I set the format of the underlying
field (in the table) to mmddyy, I get an error when I enter 051907 in the
field on the form. ("The value you entered isn't valid for this field. For
example, you may have entered text in a numeric field or a number that is
larger than the field size setting permits.)

I think it has something to do with the regional settings for short date
being set at mdyy, but I shouldn't be changing regional settings for
everyone who uses the database, should I? How can I get around that? (Or,
is my guess about regional settings not the problem?)

TIA

 

[zSplash]

Thanks, John, for the help.

In the underlying table, the field is defined as date-time, and the format
is "mmddyy".
In the form based on the table, I look at the field properties and see
"mmddyy" as the format, yet when I view the form in Form View, and enter
"051907", I get the reported error.

If I enter "05/19/07", I don't get an error, but that's not what I want to
enter. I want to be able to enter the date without slashes.

TIA

 

[zSplash]

I'm sorry, Joe. Thanks for your help so far.

What I want to do is enter dates with 6 digits, and not require slashes. Is
there any way to do this, if I define the field as a date field?

TIA

 

[John Vinson]

What I want to do is enter dates with 6 digits, and not require slashes. Is
there any way to do this, if I define the field as a date field?

Yes. Use an input mask of 00/00/00 and let Access put in the slashes
for you.

John W. Vinson[MVP]