select Date,price from dataupload where MONTH(date)=MONTH(GETDATE()-1) and day(date)=day(getdate()-1)
SELECT [Date],Price FROM Dataupload WHERE [Date] BETWEEN DATEADD(DAY,-8,GETDATE()) AND DATEADD(DAY,-1,GETDATE())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)