I just tried out the DATE() function. I never knew you could use parameters with it. I always used it as DATE().
Thanks,
Cecil
>If you want to use different dates in the sums, use an IIF() expression as what to sum, something like:
>SUM(IIF(BETWEEN(bill_date, DATE(2010,1,1), DATE(2010,1,31)), bill_prem, 0)
>I also changed your CTOD() to use DATE(), which is much safer.
>Tamar