> > If you are also storing time, then you would need to either use
> > a function (UDF) to get the date or one of the internal functions
> > of FB, for example CAST.
>
> I tried the casing without success. I tried:
>
> select cast (Action_DateTime as date) from ActionLog
>
> After looking in Borrie's text, I am guessing that IB 6 (which is
> what my ISP has, I use Firebird locally) doesn't do this correctly.

If it works for FB but not for IB, then you may have to take a different
approach. Can you use the FreeUDF library? If so, you can use the
F_STRIPTIME function to return just the date portion of a datetime field.
You could use this in a selectable SP to return the records in the correct
format, then use the aggregate group by on that.

If that's not an option, you may have to do it in code in your program.

HTH
Woody (TMW)