I need a query to pull data from 2 tables depending on the selection of the date.
If the date is selected from the previous 2 weeks, data should be extracted from one table and if the data is selected from the current and next week , it should get extracted from the other table.
Can anyone help me with this.