Description:
Switch between an Excel date/time value and a numeric value.
Syntax:
E(x)
Note:
Treat parameter x as a date/time/datetime value according to Excel rules when it is a numeric value, and convert it to a numeric value when it is a date/time/datetime value.
Return parameter x itself when its type isn’t specified. That is, do not perform the conversion when x isn’t numeric, date, time, string, sequence, table sequence, record sequence or a single value, but just return x itself.
Parameter:
|
x |
A numeric/date/time value |
Return value:
Numeric/date/time value
Example:
|
|
A |
|
|
1 |
=E(3) |
1900-01-03 |
|
2 |
=E(3.5) |
1900-01-03 12:00:00 |
|
3 |
=E(date("1900-01-02 01:04:45")) |
2 |
|
4 |
=E(datetime("1900-01-01 12:43:01")) |
1.5298726851851852 |
Return x itself when its type isn’t specified:
|
|
A |
|
|
1 |
=to(3).cursor() |
Return a cursor. |
|
2 |
=E(A1) |
Return cursor A1. |
|
3 |
=A2.fetch() |
Fetch data from cursor A2 and return [1,2,3]. |