Re: dates - InfoPath auto setting of a 4 digit year

Jimmy — Sat, 30 Jun 2012 17:29:04 GMT

The interpretation of two digit dates is a system setting that InfoPath respects (see attached).

You could have all your users change their system settings so that the current year is the cutoff year (however, they would have to update this every year and changing the setting to the current year could cause unwanted consequences for other progams).

Or you could come up with your own parsing logic, but that might be a nightmare.

Working around this by displaying dates with two digits is not a good idea, because the dates are stored internally with four digits and this could cause issues in the future.

My recommendation is to request that they enter four digit dates for years before 1930. Sounds like they are trying to have their cake and eat it too.

dates - InfoPath auto setting of a 4 digit year

karson6 — Sat, 30 Jun 2012 16:59:22 GMT

In InfoPath 2010, I have date fields set with a format of mm/dd/yyyy. A user enters the year using just the last two digits and InfoPath automatically converts it to a the 4 digit year. InfoPath is determining the the first two digits of the year to populate - this looks like a global setting for all forms.

The threshold appears occur where 30 is entered as the year. For example, if 5/1/29 is entered, InfoPath displays 05/01/2029. If 5/1/30 is entered, InfoPath displays 05/01/1930. Any two digit year entered between 30-99 is displayed with 19 preceding it, such as 1930 and 1999. Any year entered between 00-29 is displayed with 20 preceding it, such as 2000 and 2029.

Is there a way to set how the first two digits of a four digit year are automatically populated?

Could I set it where if the two digits entered are equal to or greater than the current year, InfoPath sets the year using the current century?

I know a workaround is to use a mm/dd/yy format but the users want a four digit year to display. They also don't want to be forced to type 4 digits in the field.

Thanks for any help!

General

Re: dates - InfoPath auto setting of a 4 digit year

dates - InfoPath auto setting of a 4 digit year