Date Field Formatting/Display
I've come across several instances where my users enter a date into a date field, but use a 2-digit year (3/25/15).
TrackVia accepts the value and displays the year as 0015 instead of 2015 (see attached screenshot).
Is there a way to either:
1. Force a 4-digit year when entering the value
2. Have the system resolve any 2-digit entries to the 4-digit equivalent closest to present day: "14" resolves to "2014".
2-digit years are now adjusted to the closest present year when entering dates.
John McGarvey commented
Hi DJ - thanks for the feedback.
My vote would be to enforce a 4-digit year.
This is the format required when we import a spreadsheet (YYYY-MM-DD), so it keeps the application consistent.
It also complies with ISO 8601.
Since many of us have user's outside the U.S., this will avoid confusion and errors: http://www.iso.org/iso/home/standards/iso8601.htm
We were just talking about this a couple of days ago. In the interim we could enforce a 4-digit year, but we would prefer to implement logic to determine whch century is chosen when a 2-digit year is entered. For example, we could do what MS Excel 2010 currently does where if a number from 00-29 is entered, then use the 21st century, otherwise use the 20th century.
It may make more sense to create more dynamic logic, though. One way we could accomplish this could be to use the current century for any number between 00 and 10 years in the future, otherwise use the previous century.
We would love to everyone's feedback as to what logic you would prefer when automatically determining the century of a 2-digit year.