 |
Icetips Utilities Documentation
5/15/2014 Utility Class: GetExcelDate |
|
Previous Top Next |
| Prototype: | (Long pClarionDate),Long |
| pClarionDate | Standard Clarion date. |
| Returns | Returns Excel based date value. |
A date in Excel is a value that is exactly 36161 days less than the Clarion date. So this method simply subtracts that value from the standard Clarion date value and the resulting value can be used as a date value in MS Excel.
Example:
ED Long
ITU ITUtilityClass
Code
ED = ITU.GetExcelDate(Today())
See also: