How to make a query with Google Spreadsheet, that returns rows if deadline is two weeks from today, one month from today, 2 months from today, etc

Question

I have a spreadsheet that contains several columns with project information. I basically want to modify the following formula:

=QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 )

So that it returns values in L that fall within a specific date range. The data ranges are located in specific cells—in this case P1 and P2.

I need to repeat the operation for different date ranges.

PS. Note that in P1 the cell contains the formula =today() and P2 = P1+14.