You're going to at minimum write custom SQL, but if you're wiling to do that, consider http://drupal.org/project/forena which will help you get from SQL to presentation.

Full Disclosure:  I'm the maintainer of that module.

Dave

-----Original Message-----
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Joel Willers
Sent: Monday, February 25, 2013 5:28 AM
To: support@drupal.org
Subject: Re: [support] Filter views by comparing two fields?

You'd have to break into the code for that. You could programmatically call the View (probably the best bet) or you could go into the Views display and do a test in there (not suggested).

Joel


From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out
Sent: Saturday, February 23, 2013 6:21 AM
To: support@drupal.org
Subject: [support] Filter views by comparing two fields?

Hi,

I have a content type with two date fields both with start and end dates..

I need to create a view filter that if the start date and time of fieldA is more than 15 minutes before or after the start date and time of FieldB then show it in the view..

Obviously views can compare dates to "now" or now relative to a time period but I can't see a way for views to filter based on the comparison of the value of two fields..

Anyone have any ideas?

Thanks..
--
[ Drupal support list | http://lists.drupal.org/ ]
--
[ Drupal support list | http://lists.drupal.org/ ]