I've post this topic yeserday as a bug, but I don't know this is right. Because of my doubt i post it also in this forum.
My site has Drupal 6.17, Views-6.x-2.1, Date-6.x-2.4, CCK-6.x-2.6, Views-Calc-6.x-1.3 and a lot of other modules.
I use these modules for a job-site.
Now I want to make views for reporting with Views-Calc to show totals after searching with filters from views.
The filters are from CCK-fields > date fields: field_date_submitted and field_date_archive.
Now I want to see in my report al jobs from 2009 except the jobs that are in archive before 2009,
My view to realize has the 2 date-filters exposed
1. everything with field_date_submitted before 01-01-2010
AND
2. everything with field_date_archive after 31-12-2008
But when I search with this view, I see the wrong output, I see: everything in archive after 31-12-2008 even posted after 01-01-2008 and everything posted before 01-01-2010.
The output seems like this:
1. everything with field_date_submitted before 01-01-2010
OR
2. everything with field_date_archive after 31-12-2008
I cannot use the filter with Date(node) and then select the 2 date-fields because they don't have the same dates
When I select the 2 date-fields, I only can choose for:
1. everything with field_date_submitted AND everything with field_date_archive after 31-12-2008
Or the other option is:
1. everything with field_date_submitted AND everything with field_date_archive before 01-01-2010
So, when i choose 2 seperate date filters, they must use AND but in reality they use OR between them.
I really think this is a bug in dates, all other text filters from CCK works fine.