Features in Office
CSV Import Dialog
- added support for boolean (1, 0, yes, no, true, false) and floating-point data types
- fixed all dates after 2000 appearing after import wrongly as being of the 20th century i.e. 1901 or 1902 instead of 2001 or 2002; to implement this, added config value MinimumYearFor100YearSlidingWindow, by default 1930, range of years that defines where any year expressed as two digits falls.
For date window from 1930 to 2029, two-digit years between 0 and 29 fall in the 2000s, and two-digit years between 30 and 99 fall in the 1900s.