Returning Data for Last Calendar

[BrianFawcett]

I am trying to write a SQL statement that will return only records that have been received in the last 365 days. I am getting an error for too may arguements in my statement. Can someone tell me what my problem is, I have a feeling it is quite simple.

"FROM [Data Table] WHERE [Data Table].[Date Received] > DATE(year,-1) "

 

[boblarson]

Use this instead:

"FROM [[URL="http://www.access-programmers.co.uk/forums/showthread.php?t=217418#"][COLOR=darkgreen]Data[/COLOR][/URL] Table] WHERE [Data Table].[Date Received] > DateAdd("yyyy", -1, Date())"

 

[boblarson]

Oh, and using the DateAdd with YEAR ("yyyy") instead will also account for leap years where using 365 days will not.

 

[BrianFawcett]

Bob, VBA is telling me that it expects and End of String at the "yyyy". ??

 

[boblarson]

If you are writing this in code, you can use:

"FROM [Data Table] WHERE [Data Table].[Date Received] > " & DateAdd("yyyy", -1, Date())