Hi,
So the data does not have sufficient information on whether it should be 19xx or 20xx, and Origin assumes 20xx, not sure if there is a setting to change to 19, we can look...
But here is a workaround:
Once you import your data and set the column to date, you could execute this script:
nn = date(8/1/2029) - date(8/1/1929);
col(1) -= nn; //assuming col 1 has your date data
That should change it to 1929 from 2029.
If you are using the import wizard to import, you could set the column as date and in the last page of the wizard, you can add this script to perform the subtraction as part of your import, and then save a filter and re-use filter with future files, if you need to do this repeatedly.
Easwar
OriginLab
YYMMDD Date Misinterpreted
Posted - 03/27/2009 : 9:35:29 PM
