capture TODAY Price Query

[dastr]

Hi all,
I have the following table:
Price Valid from Valid to
$2 01 Jan 12 31 Mar 12
$10 01 Apr 12 30 Jun 12
$11 01 May 12 31 July 12
$20 01 Jul 12 31 Dec 12

TODAY is June 22n2, 2012 – what query should I create to capture ALL prices valid for June? - $10 and $ 11?
Any ideas?

Thank you!

 

[recyan]

http://www.baldyweb.com/OverLap.htm

Thanks