I want to be able to have a query automattically get the previous days data. i dont want to have the user enter any dates.
heres my query:
SELECT*--,MIN(formatdate)
FROM bk_vAPTData
Where formatdate >=dateadd("D",-1,getdate())
this gives me data for both 9-19-12 and 9-20-12
how can i just get my records from 9-19-12
heres my query:
SELECT*--,MIN(formatdate)
FROM bk_vAPTData
Where formatdate >=dateadd("D",-1,getdate())
this gives me data for both 9-19-12 and 9-20-12
how can i just get my records from 9-19-12