M. David Matney
02-15-2010, 09:56 AM
Misinterpretation in the User Interface
If your date format in your country is not MM/DD/YYYY, then you may experience odd behaviors. Hopefully this will explain resolutions and what to do.
Define the date format for your locale in Windows Control Panel | Regional Settings. You can therefore use your local date format when you enter dates into the user interface part of BizWizard.
BizWizard uses Microsoft Access technology and as a result Microsoft tried to be too smart at helping accept dates. If you enter a date that is invalid for your local settings, The Dates get spinned around trying to find an interpretation that works. For example, with British dates in Control Panel, if you enter 10/13/01, BizWizard realizes there is no 13th month, and decides you must have intended 13-Oct-01. The results can be bizarre. The entry 02/29/01 should generate an error message that 2001 is not a leap year. It doesn't. Instead, BizWizard plays with the entry and decides you must have intended Feb-1-2029 !!!
Aside from this madness (which cannot be turned off), just remember the user interface in Microsoft Technology and thus BizWizard technology uses the local Control Panel settings to interpret dates typed into the user interface.
If your date format in your country is not MM/DD/YYYY, then you may experience odd behaviors. Hopefully this will explain resolutions and what to do.
Define the date format for your locale in Windows Control Panel | Regional Settings. You can therefore use your local date format when you enter dates into the user interface part of BizWizard.
BizWizard uses Microsoft Access technology and as a result Microsoft tried to be too smart at helping accept dates. If you enter a date that is invalid for your local settings, The Dates get spinned around trying to find an interpretation that works. For example, with British dates in Control Panel, if you enter 10/13/01, BizWizard realizes there is no 13th month, and decides you must have intended 13-Oct-01. The results can be bizarre. The entry 02/29/01 should generate an error message that 2001 is not a leap year. It doesn't. Instead, BizWizard plays with the entry and decides you must have intended Feb-1-2029 !!!
Aside from this madness (which cannot be turned off), just remember the user interface in Microsoft Technology and thus BizWizard technology uses the local Control Panel settings to interpret dates typed into the user interface.