"ExcelDate" (Interpreter Type)

A numerical date in the Microsoft Excel standard.

Details

  • "ExcelDate" can be used in Interpreter and related constructs, including deployed smart form fields.
  • Use of "ExcelDate" does not require connectivity to the Wolfram Cloud.

Allowed Forms

  • 12345number of days since epoch (December 30, 1899)
    123.45a time of day on the 123^(rd) day since epoch

Restriction Specifications

Interpretation

Examples

Basic Examples  (3)

Interpret Excel dates:

In[1]:=
Click for copyable input
Out[1]=
In[2]:=
Click for copyable input
Out[2]=

Restrict the value to be within a given range:

In[1]:=
Click for copyable input
Out[1]=

Set a resolution:

In[1]:=
Click for copyable input
Out[1]=

Related Interpreters

See Also

Interpreter  Restricted  Failure