date1904 {datetimeutils}

Is File Origin 1904?

Description

Checks whether an xlsx file uses 1 Jan 1904 as its origin.

Usage

date1904(filename)

Arguments

filename

character: one or more filenames

Details

Requires utils::unzip.

Value

A logical vector: TRUE if origin is 1904; FALSE if origin is 1900; NA if file could not be processed.

Author(s)

Enrico Schumann; type spss/pspp suggested and based on a patch by J\"org Beyer

References

ECMA-376-1:2016 Office Open XML File Formats.

See Also

convert_date

Examples

date1904("~/Desktop/02_company_statistics.pdf")