I need your help in writing a date query to find out friday's date from 3 weeks prior when I run it for current date. And if the current date is friday then I need to get friday's date from 2 weeks prior.
If I run the query for date: 2013-06-12, I should get the date: 2013-05-24.
If I run the query for date: 2013-06-14, I should get the date: 2013-05-31.
Thanks a lot!!