Hello,

I am concerned as similiar queries, only changing the way I specify the
dates, give different results.

Query A would use EXTRACT, example:
EXTRACT(month FROM accountingdate)=' . $currentmonth . '

Query B would use <>=, example:
accountingdate>=' . $begindate . '

Now the odd thing is that I get different results, for a sum of sales
figures. A quick check of the actual sales summed up outside of the
database reveals that Query B gives the correct answer.

Now this is a major concern as I just Query A type syntax in some other
reports. Why doesn't it work correctly? Any links to more information
about extract? The manual information suggests that Query A should be
synonymous with Query B.

Thanks for any information