Or maybe it should be lnNumeric = lnDate - DATE(1800, 1, 1) + 1?


>ldDate = DATE(2002, 1, 1)
>lnNumeric = lnDate - DATE(1800, 1, 1)
>
>
>>Hi,
>>Any function that can convert date to numeric format that starting point is from 01/01/1800?
>>
>>Or, any sample code?
>>
>>Thank you