Query based on Fiscal Quarters

[Wet_Blanket]

Good Morning,

I have a query that identifies records based on dates. I currently have it set up to identify all records within the last year. Here is the little code.

>Now()-"366"

However, I want to put in a formula that will select a year time frame based on the last quarter. For example, if I ran it today, it would show records from 7/1/2010 - 06/30/2011. I can manually do this, but I would like a formula so I don't have to update the query everytime I run it.

Suggestions?

 

[Taruz]

Hi..

Try this way criteria.

Between dateserial(year(date())-1;month(date());1) and dateSerial(year(date());month(date());0)

 

[Wet_Blanket]

Thanks, but Access doesn't seem to like those semi colons in there.

 

[Taruz]

My English is not very good. I do not want to mislead .. As far as I understand it..:

If you use this criterion in the query, sql view, try to change semicolons commas..

 

[Wet_Blanket]

Taruz, awesome - worked like a charm!

Here is the updated code.

Between dateserial(year(date())-1,month(date()),1) and dateSerial(year(date()),month(date()),0)