Exoffice v0.3.2 Exoffice.Parser.Excel2003.Date

Link to this section Summary

Functions

Converts date from excel to erlang datetime

Link to this section Functions

Link to this function to_date(value, base_date)

Converts date from excel to erlang datetime

Parameters

  • value - date from the excel file (usually a number, e.g. 40908.0)
  • base_date - base_date field from the excel struct. Defines Windows or Mac date (1900 or 1904)

Example

iex> Exoffice.Parser.Excel2003.Date.to_date(40908.0, 1904) {{2016, 1, 1}, {0, 0, 0}}