"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
-
12345 number of days since epoch (December 30, 1899)123.45 a time of day on the 123^(rd) day since epoch
Restriction Specifications
Interpretation
- "ExcelDate" yields a DateObject .
Examples
Basic Examples (3)
Interpret Excel dates:
Restrict the value to be within a given range:
Set a resolution:
See Also
Interpreter Restricted Failure
Interpreter Types: Time Date DateTime DayOfWeek UnixTime StructuredTime ComputedTime StructuredDate ComputedDate StructuredDateTime ComputedDateTime