ELDateToDateTime: Difference between revisions
From MultiCharts
no edit summary
(→Usage) |
No edit summary |
||
(One intermediate revision by one other user not shown) | |||
Line 3: | Line 3: | ||
EL Date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month. | EL Date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month. | ||
The integer portion of the DateTime value indicates the number of days that have elapsed since | The integer portion of the DateTime value indicates the number of days that have elapsed since December 30th, 1899, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | ||
==== Usage ==== | |||
<syntaxhighlight>ELDateToDateTime(YYYMMdd)</syntaxhighlight> | |||
Where: [[YYYMMdd]] - a numerical expression, specifying the date in EL YYYMMdd format | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight>ELDateToDateTime(1080101) will return a value of 39448.00000000, corresponding to the specified | <syntaxhighlight>ELDateToDateTime(1080101) will return a value of 39448.00000000, corresponding to the specified |