SQL For Getting Records in a Date Range 1

[gall3on]

Hi,

I'm still feeling my way around SQL and need some assistance.

I have the following SQL below:
SELECT [All SOS with All CIDs].Date, [All SOS with All CIDs].SOS, sum([All SOS with All CIDs].Sumits) AS Submits INTO [Two Weeks]
FROM [All SOS with All CIDs]
WHERE ((([All SOS with All CIDs].Date) Between [Enter Start Date] And [Enter End Date]))
GROUP BY Date, SOS;

Basically, it helps me pull records within a certain date range.

How would I change this code if I want it to find records for the latest 14 days without having to put in dates? I just want it to return records from the latest 14 days.

 

[Golom]

SELECT A.[Date], A.SOS, SUM(A.Sumits) AS Submits INTO [Two Weeks]
FROM [All SOS with All CIDs] As A
WHERE A.[Date] Between DateAdd("d", -14, Date()) And Date()
GROUP BY [Date], SOS;

 

[gall3on]

Wow, that was a pretty awesome solution. Thanks Golom!

 

[PHV]

Another way:

SELECT [Date], SOS, SUM(Sumits) AS Submits INTO [Two Weeks]
FROM [All SOS with All CIDs]
WHERE (Date()-[Date]) Between 0 And 14
GROUP BY [Date], SOS;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886