Date Question

[Cardinal]

I have a form displayed as a datasheet and one of the columns in that
datasheet displays dates in this format: 11/20/08, Thu. When I go to
edit a date, I'm thinking that I should be able to change individual
numbers but the application will not let me do that. In other words,
if I want to change the day part of the date from 20 to 21, I should
be able to edit out the zero and replace it with a one. When I do
this, however, the application throws up an error message that states:
"The value you entered isn't appropriate for the input mask
'99/99/00;0' specified for this field." When I retype the entire date,
then it works fine. Is there anyway I can make smaller editing changes
and have this work? Thanks very much.

 

[Dorian]

It should work if you delete the 0 and then insert the 1.
However, if you try to insert the 1 first, it wont work because you'd end up
with a day of 201
Masks are a real pain, I would not use them.

-Dorian

 

[Arvin Meyer [MVP]]

Try removing the input mask from the form and the table and use the Short
Date format property to display it the way you want.