>I am playing with the DBI ctgrid activex. Got everything working but I need to convert my date field to an integer.
>
>I am trying this but no luck,

Check Re: Clng equivalent Message #1024557. The oposite conversion would be

ldDate = DATE()
lnSerNum = ldDate - {^1899/12/30}