Re: [Q]DATETIME convert to DATE
yan,
try something along these lines:
select count(*)
from <your_table>
where extend(<your DTYM column>, YEAR TO DAY) > DATE(<any date>)
with the extend function you can effectively adjust the precision of a
datetime variable. there are caveats involved here when converting values to
higher precisions. i would read the 4gl manual to gain some understanding of
these to ensure you won't be affected adversely.
-jason