[66stang]

I have a form that requires dates to be entered into it, this form was
originally created in Word 97. After migrating to Word 2007 a problem
appeared in that when a user was trying to enter the date April-05, it
defaulted to the year to 08. I went into the Text Form properties and
changed the date format to XXX-yyyy from XXX-yy. This fixed the problem as
long as you enter the year as yyyy, if you only enter the year as yy it will
convert this to the year 2008 no matter what year you typed in. This being a
form I can not guarentee that all users will enter the year using yyyy no
matter how many directions given to them.

Is there a fix for this?

Thanks

[Graham Mayor]

If you set the field type to date and only type part of the date ie 04/05
for April 05 then Word fills in the current year to produce 04/05/08 which
means that if you have a date switch MMMM-yy you would get MAY-08 and not
APRIL-05 (the exact result depending on the language settings that determine
the date format at your location). The only way to avoid this is to enter
the complete date.ie 13/04/05 or 13/04/2005 which will give you APRIL-05.
The only alternative is to make this a Text field and then you can type
anything in it, but then you would have to rely on the user typing the date
format correctly. Either way you can add help text to the field to explain
to your users what is required.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



66stang wrote:
I have a form that requires dates to be entered into it, this form was
originally created in Word 97. After migrating to Word 2007 a problem
appeared in that when a user was trying to enter the date April-05, it
defaulted to the year to 08. I went into the Text Form properties and
changed the date format to XXX-yyyy from XXX-yy. This fixed the
problem as long as you enter the year as yyyy, if you only enter the
year as yy it will convert this to the year 2008 no matter what year
you typed in. This being a form I can not guarentee that all users
will enter the year using yyyy no matter how many directions given to
them.

Is there a fix for this?

Thanks

[66stang]

Thank you

Not the answer I was hoping for but at least now I understand why it is
happening.

I will add the help text and hope for he best!!



"Graham Mayor" wrote:

If you set the field type to date and only type part of the date ie 04/05
for April 05 then Word fills in the current year to produce 04/05/08 which
means that if you have a date switch MMMM-yy you would get MAY-08 and not
APRIL-05 (the exact result depending on the language settings that determine
the date format at your location). The only way to avoid this is to enter
the complete date.ie 13/04/05 or 13/04/2005 which will give you APRIL-05.
The only alternative is to make this a Text field and then you can type
anything in it, but then you would have to rely on the user typing the date
format correctly. Either way you can add help text to the field to explain
to your users what is required.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



66stang wrote:
I have a form that requires dates to be entered into it, this form was
originally created in Word 97. After migrating to Word 2007 a problem
appeared in that when a user was trying to enter the date April-05, it
defaulted to the year to 08. I went into the Text Form properties and
changed the date format to XXX-yyyy from XXX-yy. This fixed the
problem as long as you enter the year as yyyy, if you only enter the
year as yy it will convert this to the year 2008 no matter what year
you typed in. This being a form I can not guarentee that all users
will enter the year using yyyy no matter how many directions given to
them.

Is there a fix for this?

Thanks