Date filter does not respect view's and/or grouping

I have a content type built with CCK and using a Date field. I tried to create a view that would list all of the nodes where the FROM date is between today and 90 days from now OR the To date is already past, but the TO date is yet to happen. So my view filter had two groups. The Operator to use on all groups was set to OR. The Group Operator for both groups was set to AND. The first group had a filter for FROM date between now and now + 90 day. The second group had a filter for TO Date >= now AND filter for FROM date < now.

In the settings for each filter I only had one date field selected. I would not have thought that the method would have affected my filters but it did, and I couldn't get any combination of ORs and ANDs in the Methods of the 3 filters and the ORs and ANDs in the views grouping to create the overall filter that I need.