OpenersNotesSection(Spacer1)Details

OpenersPrimaryExamplesSection(Spacer1)Examples  (3)

OpenersExampleSection0(Spacer1)Basic Examples  (3)

Interpret Excel dates:

Interpreter["ExcelDate"]["30591"]

Interpreter["ExcelDate"]["51212.13"]

Restrict the value to be within a given range:

Interpreter[Restricted["ExcelDate", {(DateObject["Fri 1 Sep 1933", DateObject[{1933,9,1}]]),(DateObject["Fri 1 Sep 1933", DateObject[{1933,9,1}]])+Quantity[3,"Month"]}]]["12345.67"]

Set a resolution:

Interpreter[Restricted["ExcelDate", {(DateObject["Fri 1 Sep 1933", DateObject[{1933,9,1}]]),(DateObject["Fri 1 Sep 1933", DateObject[{1933,9,1}]])+Quantity[3,"Month"],"Day"}]]["12345.67"]

({{DocumentationFooterIconsRelatedFunction.png, ({{See Also}, {(RefLink[Interpreter, paclet:ref/Interpreter])  ▪  (RefLink[Restricted, paclet:ref/Restricted])  ▪  (RefLink[Failure, paclet:ref/Failure])}, {Related Interpreter Types:  (RefLink[Time, paclet:ref/interpreter/Time])  ▪  (RefLink[Date, paclet:ref/interpreter/Date])  ▪  (RefLink[DateTime, paclet:ref/interpreter/DateTime])  ▪  (RefLink[DayOfWeek, paclet:ref/interpreter/DayOfWeek])  ▪  (RefLink[UnixTime, paclet:ref/interpreter/UnixTime])  ▪  (RefLink[StructuredTime, paclet:ref/interpreter/StructuredTime])  ▪  (RefLink[ComputedTime, paclet:ref/interpreter/ComputedTime])  ▪  (RefLink[StructuredDate, paclet:ref/interpreter/StructuredDate])  ▪  (RefLink[ComputedDate, paclet:ref/interpreter/ComputedDate])  ▪  (RefLink[StructuredDateTime, paclet:ref/interpreter/StructuredDateTime])  ▪  (RefLink[ComputedDateTime, paclet:ref/interpreter/ComputedDateTime])}})}})

({{DocumentationFooterIconsRelatedGuide.png, ({{Related Guides}, {▪(RefLinkPlain[Setting Up Input Interpreters, paclet:guide/InterpretingStrings])}})}})