>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,
May be:
? DATE()-DATE(1900,1,1) will do the job.
I am not familiar with ctGrid and I don't know what are the vaules of the date there.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.