re: "can importing and exporting software into and out of two different programs that use 2 digits and 4 digits." The simple answer is that it is hardly conceiveable you will have a problem.
The longer discussion:
Quicken says that is compliant, correct? MS Excel, for example, is also compliant (whatever that means).
When, in Excel, you enter a date into a field, the system actually stores it as a number of elapsed days since January 1, 1900. The format of the cell allows you to see the date in the notation you desire. 1/1/1900 is actually the number "1", 1/2/1900 is actually the number "2" and so on. This is important because it eliminates any ambiguity going forward - but has nothing to do with how the information is actually entered. (Have I confused you? Hope not.)
As far as entering information by hand or through an import or a copy/paste operation is concerned, if Excel sees that the format of a string looks like a date (e.g. 7/25/2002), it will automatically convert it. If it sees a 4 digit year, there is no ambiguity and no problem. If it sees a 2 digit year, it follows rules. Today with the current version of Excel, if the date you enter is 7/25/02, Excel assumes you mean 2002. If, on the other hand, you really meant 1902, you enter a 4 digit year - 7/25/1902; and move on. Excel translates the date you entered to the number of elapsed days since 1/1/1900. Excel assumes that any reference to a 2 digit year between the numbers 00 and 29 refers to the years 2000 through 2029; and that any two digit year between the numbers 30 and 99 refers to 1930 and 1999. You override that by entering a 4 digit year.
So. Assuming that a Quicken export understands those rules (a safe assumption), if your dates are correctly stored in Quicken (e.g. correct year notations), then any export facility provided by Quicken should allow the information to be imported without problem. It should also work without problem the other way (e.g. spreadsheet to Quicken). |
