Query over past six CALENDAR months

[Courtman]

Hiya all

I'm trying to write a query which looks back over the past six calendar months - i.e. from today back to 01-Mar-2008. Can anyone recommend the easiest way to do this in a query please?

Thanks!

 

[MagicMan]

Assuming your table date is date format

strSql = Select * From yourtable Where yourdbdate > #' & Dateadd("m",-6,Date) & "#"

If you want the first day of the month, then use

strSql = Select * From yourtable Where yourdbdate > #' & DateSerial(Year(Date()), Month(Date())-6,1)
 & "#"

 

[Courtman]

Brilliant, my SQL query now looks like this:

SELECT Sum([Log Entries].[Instr Apps]) AS [SumOfInstr Apps]
FROM [Log Entries]
WHERE [Log Entries].[Date] > DateSerial(Year(Date()), Month(Date())-6,1);

and works perfectly. Thank you!

 

[MagicMan]

Glad I could help.
Smiles
bob