SQL code for getting the last 2 weeks of rolling data
This code will automatically update you view of data to include data
starting 14 days prior. By changing the number you can adjust this code
to your needs.
|
--Change the number to the amount of days you want to start
from.
SELECT *
FROM YourTable
Where YourDATE > GETDATE() - 14
|
| 
