In query, get a value from last year's end quarterly date.

[mcupito]

Hi, all.

I'm attempting to compare values from this year's ending quarter, and the previous years.

In the Criteria for the query, I tried:

DateAdd("q",-4,Date)

Which didn't work. Any ideas?

[Seth Schrock]

In SQL, the date function is used like this: Date(). So your criteria would be

DateAdd("q", -4, Date())

[mcupito]

Thanks again, Seth! It seems I must have seen 'Date' somewhere and had that on my mind rather than 'Date()'

[Seth Schrock]

In VBA, you would just enter Date so that may have been where you have seen it. It works the same with the Now, Day, Month and Year functions. VBA leaves out the parenthesis and SQL includes them.

[mcupito]

Thanks, Seth! You are correct - that's where I saw it.