Description: dBASE Level 7 DBF supports the timestamp field (type '@'). Valid DBF files generated from dBASE are flagged as corrupt and LibreOffice fails to repair them Steps to Reproduce: 1. Download sample file https://github.com/SheetJS/test_files/raw/master/dbf/d11.dbf 2. open in LibreOffice Actual Results: Error message "The file 'd11.dbf' is corrupt and therefore cannot be opened. LibreOffice can try to repair the file." Attempting to repair the file yields a new error message "The file 'd11.dbf' could not be repaired and therefore cannot be opened." Expected Results: The file opens properly and the field is interpreted as Date Reproducible: Always User Profile Reset: Yes Additional Info: SheetJS currently uses the following algorithm to extract values. The algorithm agrees with dBASE 2019 on the values in the test file: - Parse the 8 bytes of the field as an IEEE754 double in big-endian order - Subtract 0x388317533400 (62135683200000, a number that can be exactly represented in a IEEE754 double) - Interpret the code as milliseconds since January 1 1970 (which is what JS uses as the 0 value for the native Date object)
*** This bug has been marked as a duplicate of bug 143715 ***