Depending on what he's after, either one could be correct.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer