View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Dates in Text Form Field

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