Hi,
I suddenly started getting this error when copying data to xlsx file:
Invalid value for parameter "Date": -686654 is not on the range -657435 - 2958466
I narrowed it down to one (incorrect) date value in the year "0016" (wrong user input, this should have been 2016 obviously), so for me the problem is fixed by correcting the data.
Creating a xlsx file with just one worksheet works without error but 'Copy all as xlsx' gives me the error above
Simplified example to reproduce the error:
--Excel=c:\temp\test.xlsx
--Records=All
--TAB=tab1
SELECT to_date('01/01/' || to_char(20 - LEVEL) || '20','DD/MM/YYYY') AS my_date FROM dual t CONNECT BY LEVEL
I suddenly started getting this error when copying data to xlsx file:
Invalid value for parameter "Date": -686654 is not on the range -657435 - 2958466
I narrowed it down to one (incorrect) date value in the year "0016" (wrong user input, this should have been 2016 obviously), so for me the problem is fixed by correcting the data.
Creating a xlsx file with just one worksheet works without error but 'Copy all as xlsx' gives me the error above
Simplified example to reproduce the error:
--Excel=c:\temp\test.xlsx
--Records=All
--TAB=tab1
SELECT to_date('01/01/' || to_char(20 - LEVEL) || '20','DD/MM/YYYY') AS my_date FROM dual t CONNECT BY LEVEL
